Determine if all checkboxes are checked


I have a row of checkboxes, and I am trying to come up with a formula that determines if all checkboxes have been checked, but keep getting unparseable, looks like the below screenshot.

These are two formulas I've tried but haven't gotten anywhere:

=IF(COUNTIF([Done? (10)]@row = 1:[Done? (9)]@row=1:[Done? (8)]@row=1:[Done? (7)]@row=1:[Done? (6)]@row=1:[Done? (5)]@row=1:[Done? (4)]@row=1:[Done? (3)]@row+1:[Done? (2)]@row=1:[Done? (1)]@row=1)=10,"Completed","Initiated")

=IF(COUNTIF([Done? (10)]@row, [Done? (9)]@row, [Done? (8)]@row, [Done? (7)]@row, [Done? (6)]@row, [Done? (5)]@row, [Done? (4)]@row, [Done? (3)]@row, [Done? (2)]@row, [Done? (1)]@row) = 10, "Completed", "Initiated")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!