How to create list from checkboxes using Numbers on iPad?

Question

Level 1

0 points

How to create list from checkboxes using Numbers on iPad?

I am creating a guest list using Numbers foriPad. First sheet is a list of invited people with checkboxes (Yes/No/still to reply) in next column. In the next sheet i want create a list of everyone that has replied yes.

I have tried using the if statement, but I dont want any blank cells.

-IF(A2;TRUE;A1) gives name in A1 if box is checked, but gives 0 or something else if i specify. But i want to automatically start on next row to avoid blank or 0-cells. Anyhelp would be appreciated.

iPad 2, iOS 6.1.3

Posted on Sep 2, 2013 7:23 AM

Reply

Answer 1

Sep 2, 2013 7:52 AM in response to haulvi

use ther countif() function where the first argument is the range of cells to check, and the second argument is the condition... something like:

=sumif(A, TRUE)

this will count the checkboxes in column A that are checked

Reply

Answer 2

haulvi Author

Level 1

0 points

Sep 2, 2013 8:01 AM in response to Wayne Contello

This isnt really what I need and I have already done this. I dont need the number of boxes checked, I need to make a list of names of everyone that has ticked checkbox.

Example:

David V

Lisa. V

Derek

Brad. V

Paul.

John

The separate list in another sheet should then be:

David

Lisa

Brad

Thanks

Reply

Answer 3

Sep 2, 2013 8:14 AM in response to haulvi

Can you use the the reorganize panel to sort the list?

Idon't have Numbers on the iOS so I am not sure. You are posting in the forum for Numbers on Mac OS X.

you can also add a new column (let's say C)

where

C1=if(A1, A1, "")

this will include the name from column A when the checkbox in B is checked. You can then copy column C and paste values using the menu item (Edit > Paste Values, or equivalent in iOS... not sure what it is)

Reply

Answer 4

haulvi Author

Level 1

0 points

Sep 2, 2013 8:20 AM in response to Wayne Contello

Sorry, didnt realize i was in the OS X forum. I'll post in the correct forum. Thank you!

Reply