Why do empty rows get added after I save and then open a worksheet

Amy Desiderio

I am trying to calculate "open activities" using a simple formula =COUNTIF([Activity Complete]:[Activity Complete], 0) in the sheet view. It's right when I save (say 70 open items where Activity Complete is not checked). Then I go back into the sheet and there are 10 empty rows added but the formula is still counting them. So now the answer in the sheet summary is 80... which is wrong, because these are blank rows and shouldn't be counted. How can I work around this?

Andrée Starå

Hi @Amy Desiderio

I hope you're well and safe!

It's by design, so there will always be 10 more rows ready for input.

You can add a -10 to the formula, and then it will work.

Would that work/Help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Amy Desiderio

I hope you're well and safe!

It's by design, so there will always be 10 more rows ready for input.

You can add a -10 to the formula, and then it will work.

Would that work/Help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Amy Desiderio

that seems to work as long as all sheets consistently have 10 blank rows upon opening... Thanks!

Andrée Starå

@Amy Desiderio

Excellent!

You're more than welcome!