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


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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!