Count number of unchecked boxes

To count the number of unchecked boxes I'm using the formula:  =COUNTIF([% Complete]3:[% Complete]60, 0).  The issue is that it is also counting blank rows.  How do I get it to only count actual blank checkboxes? 

action items.PNG

Tags:

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!