Count number of unchecked boxes
Comments
-
My personal workaround was to create another checkbox column called "Header" and check that box if a row is header type row or maybe a divider. Then I hide that column.
Then using COUNTIFS to look at the header column and the % column
=COUNTIFS([% Complete]3:[% Complete]60, 0, Header3:Header60,0)
Maybe there is an easier way but that's the way I've been doing it.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!