Formulas

Liz de Pass

Hi

I need to create a formula whereby the number of checked boxes within a column are subtracted from a certain number. Is that possible?

Liz

 

Jenny Lam

Hi Liz, please try if this is what you are looking for:

 

Example - count the "Done" column, and subtract from 10.

 

=10-COUNTIF(Done:Done, 1)

 

Reference: http://help.smartsheet.com/customer/portal/articles/775363#advanced

Liz de Pass

Thanks Jenny,

I've tried that and get #UNPARSEABLE

however, I've got around it by creating parent/children and without the 10- bit, so it's just a total of ticked checkboxes.

Thanks

Liz