Column with a running total by location


I have a column for Address, City, and State. When entering data I am able to get a column that will count the total for each, but I want to add a column that shows the running total for each.

For example in row 1 I enter data for location x the running total would show 1. Then in rows 2 and 3 I enter data for location y the running total should who 1 in row 2 and 2 in row 3.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!