How do I write a formula to count rows in a dynamic sheet that sheet that keeps growing? How do I reference a column when we don't know where the end will be?

Thank you

Best Answer


  • Thank you, KDM. This worked perfectly both on the same sheet and in the cross referenced sheet. Awesome.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!