9 Replies Latest reply: Feb 5, 2013 6:24 AM by Jerrold Green1
The_Drew Level 1 Level 1 (10 points)

Is it possible to have mutually exclusive checkboxes on a canvas? i.e. 3 checkboxes but only one of them can be selected at any time?


iMac 27" i5., Mac OS X (10.6.2)
  • 1. Re: checkboxes in numbers
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Drew,

     

    What you describe is generally known as a set of "Radio Buttons". Numbers does not support this format. The best you can do, in my opinion, is to alarm the condition where the number of TRUE boxes is not equal to 1.

     

    A Conditional Format to turn the Fill to the color Red when the wrong number of boxes are checked will do that in a cell with a COUNT function.

     

    Jerry

  • 2. Re: checkboxes in numbers
    The_Drew Level 1 Level 1 (10 points)

    I need something a bit more idiot proof than conditional formatting, though I'm really grateful for the suggestion!

     

    I've tried using the list feature with nested IF functions and that seemed to give a result similar to what I was seeking: Radio buttons would be a nice feature though, so I'll add that as a feature request, just on the odd chance Apple decides iWork 09 should be updated (we can hope...).

     

    Thanks for your help!

  • 3. Re: checkboxes in numbers
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Drew,

     

    You might find that LOOKUP does a better job than nested IF statements.

     

    Jerry

  • 4. Re: checkboxes in numbers
    Wayne Contello Level 6 Level 6 (13,615 points)

    Popup menus provide mutually exclusive selections-- they can also be a pain for other reasons.  You should try them and see if they do the job for you.

  • 5. Re: checkboxes in numbers
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Wayne,

     

    I think that Drew's "list feature" is your Pop-up.

     

    Jerry

  • 6. Re: checkboxes in numbers
    The_Drew Level 1 Level 1 (10 points)

    Sorry wrong vernacular. List = Pop-up menu.

     

    Thanks to all for your suggestions, I'm now playing around with LOOKUP and reasilsing I'm completely out of my depth :-)

  • 7. Re: checkboxes in numbers
    Wayne Contello Level 6 Level 6 (13,615 points)

    with a lookup you can take a key value and locate that value in one column of a table, then return the value of another cell (from the same row) in a different column.

     

    If you post a screen shot of your existing table I am certain Jerry or I can help

  • 8. Re: checkboxes in numbers
    The_Drew Level 1 Level 1 (10 points)

    Thanks Wayne, I'm updating the spreadsheet right now to include the Pop-up menu's, (there's a lot of fields), when that's finished I'll post a screenshot.

     

    Thanks in advance for all your help!

  • 9. Re: checkboxes in numbers
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Drew,

     

    Don't go too far until you give it a test run. As Wayne noted, Pop-up list format has some issues that you may want to explore before you go all-in.

     

    Jerry