Workaround for countif miscalucating unchecked boxes in column

edited 02/19/24 in Formulas and Functions

Looking for any advice, guidance, on calculating unchecked boxes. I would like to use summary data and post to a dashboard for review and status of how many unchecked rows. However, it counts the added/unused rows at the bottom of the sheet showing an incorrect calcuating of unchecked marked boxes.

We add rows to the sheet often and its adds more rows to the bottom of the sheet, so the formula using the -# (suggested in this post: would not be correct.

Welcome any help to this new smartsheet user.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!