2540 Views 1 Reply Latest reply: Mar 14, 2011 10:11 AM by jaxjason
basically your just looking to populate another cell with a value next a check box, only if that check box is checked?
This can be done with the IF statement. You would have a list that is the exact length as your orignal list, but it would only show data where they checked boxes.
I made a default spreadsheet with two sheets and one table each. In the 1 sheet, cell A2 is my check box and a value is in B2. In b2 of my other sheets table I put in this formula:
IF(Sheet 1::Table 1::A2,Sheet 1::Table 1::B2,"Not Checked")
You would just replace the "Not checked" with an empty string "" for your purposes.