One check box as true at a time?

What you're asking for is a way to format a group of cells to act as 'radio buttons.' Not a supported feature, unfortunately.

But you can provide a warning, as suggested by Yvan, or using the smilar method below, which highlights the checked cells when, as shown, more than one in the set is checked.

The formula in A1 can be placed anywhere in the document. All nine of the checkbox cells (B2:B10) have the same pair of conditional rules applied:

The first rule may appear redundant, as it sets a conditional format that has exactly the same appearance as the default format—a white fill. It's purpose is to avoid the second rule being applied to unchecked cells in the group.

Incidently, the technique is easily revised to change the maximum number of allowable checks in the group of cells. Just change the 1 in the formula to the desired maximum.

Regards,

Barry

It seems to me that if you really want a "Radio Button" User interface then you need to use the closest item Numbers has. Radio Buttons allow a single selection of a set (That is they are mutually exclusive). The check boxes cannot enforce this so the next best element that numbers has is a Pop-Up menu. You can set the contents of the pop up using the inspector for the menu.

I hope this helps

Wayne

Gill,

You could do something like this:

The expression in the Result table, cell A2 here, is:

=IF(COUNTIF(T1 :: A,TRUE)<1, "Please Make a Selection", IF(COUNTIF(T1 :: A, TRUE)=1, LOOKUP(TRUE,T1 :: A,T1 :: B), "Please select only one"))

where T1 is the name of your main table.

Jerry

As far as I know, there is no way to guarantee that only one box is checked in a column.

There is a workaround : create a table with a single cell.

In this cell, insert this kind of formula :

=IF(COUNTIF(Table 1 :: B,TRUE)>1,"CAUTION. several boxes are checked !","")

Yvan KOENIG (VALLAURIS, France) lundi 30 mai 2011 19:14:41

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.7

Please : Search for questions similar to your own before submitting them to the community

To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

(1) radio buttons doesn't exist in Numbers

(2) even if they are delivered in a future version, they would be able to replace a set of checkboxes in a row.

Here the asker want to have a single selected checkbox in a column.

It's not a feature which would be offered by radio buttons.

Yvan KOENIG (VALLAURIS, France) mardi 31 mai 2011 16:33:21

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.7

Please : Search for questions similar to your own before submitting them to the community

To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

Thanks Jerrold.

You responded while I was eating. So, now I'm free for other tasks 😉

Yvan KOENIG (VALLAURIS, France) mardi 31 mai 2011 20:31:19

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.7

Please : Search for questions similar to your own before submitting them to the community

To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !