Sheet defaults to 50 rows

Sldollman

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?

Mark Cronk

Hi @Sldollman ,

Change your formula to a COUNTIFS and add a criteria that looks for an entry in another column in completed rows. Blank rows won't have data in the other field and won't be counted.

Need more help?

Mark

Sldollman

Thanks, Mark. This will work.