Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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
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
