checkboxes in numbers

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

Drew,

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

Jerry

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.

Wayne,

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

Jerry

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

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