Workaround for countif miscalucating unchecked boxes in column

Jolen

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: https://community.smartsheet.com/discussion/94783/countif-formula-calculating-a-checkbox-column-incorrectly) would not be correct.

Welcome any help to this new smartsheet user.

Paul Newcome

You would need to pick a column that will always have data in it and then include that as another range/criteria set in your COUNTIFS.