Am I able to put more than one tickbox in a cell? If so, how?
MacBook Pro 13″, macOS 12.6
NO, each cell can only hold one Checkbox!
If you would have multiple checkboxes in one cell it would be impossible to get the status of these checkboxes.
Numbers can only get status of cell C3 and see if the checkbox is selected or not.
If C3 would contain multiple checkboxes you would need a separate address for each box.
Ralf
Basically I have sandwich options for packed lunches throughout a lengthy period of time and adults are allowed to double up on the order. Some order different fillings but some would like two of the same. I have a spreadsheet with tickboxes which are then added up to a total number at the bottom of each column based on the tickboxes being ticked. However, if someone wants two of one, what would be a better way round of doing this? I hadn't thought about the double up until after I had gone down this route.
I assume you want to click click click, not use the keyboard. Otherwise I would suggest typing a number into the cell.
There are several other formats you can choose from: Pop up menu, slider, stepper, and star rating.
Star rating would be the least number of clicks but you have to be really careful. If you click in a cell with a star rating, it will pick whatever rating you clicked closest to and give you that many stars. In my opinion it is a bit too easy to accidentally click in a cell and change a rating, though. I think the keyboard is necessary to reset it back to 0 stars (by typing a zero) but maybe there is a way I am not aware of. And it is limited to the values 0-5.
The others require clicking in the cell then clicking at least once more to select a number. You can't accidentally change one with an errant click (not easily anyway) but the tradeoff is the extra click(s).
With star, slider, and stepper you can type a number instead of clicking.
Hi YorkshireKnock,
See if this works for you.
Formula in B2: COUNTIF(C2:E2,TRUE)
Row 8 is a Footer Row. Formula in B8: SUM(B)
Regards,
Ian.
YorkshireKnock wrote:
Am I able to put more than one tickbox in a cell?
What is your aim in doing that? If you explain maybe we can suggest a way that will work in Numbers.
SG
Tickboxes in Numbers
