Sheet defaults to 50 rows

I have a sheet with 17 rows of data. Smartsheet automatically adds additional blank rows to equal 50 rows total.

I'm attempting to count UNchecked checkboxes in the sheet, but I'm unable to get a valid number. In other sheets with more rows of data, I'm able to subtract 10 from the formula (since 10 is the standard auto-generated number of blank rows). But it seems that if you have less than 40 populated rows, it will add extras to equal 50.

I'm experiencing this with multiple sheets.

How can I count unchecked boxes in this scenario?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!