Formula to automatically input total number of rows

edited 12/09/19 in Formulas and Functions

Hello! I'm hoping one of you smart people can help me...


The "$A$70" value in the calculation below is the number of rows in the sheet

I want to replace the "$A$70" value with a calculation (or whatever it's called in this case) to automatically update the "70" dynamically with however many rows in are in the spreadsheet so that whenever new rows are added or deleted, the value will change automatically.

Can someone help me do that please?



Thanks a million, gang!





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!