How do I stop blank rows from being added and being count in my formula?


I have a table of 154 rows. I need to know how many are blank. There are actually three, but Smartsheet automatically adds ten blank rows (no matter how many times I delete them) so the formula says there are 13 blank cells! There aren't; there are three!

How do I stop Smartsheet from adding ten blank rows?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!