Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
How to write a running total in a list
Hello, I am wondering how to write a running total in a list where the first occurrence will have a value of 1, the second occurrence will have a value of 2, and so on. In Excel, the formula would use COUNTIF but I can not find the smartsheet counterpart.
Thanks everyone!
Answers
-
From what I understand you can have a ROWID column and use a formula like
=SUMIFS(<Column/Range whose total you need>, ROWID:ROWID, @cell <= ROWID@row)
it will give you running total.
Parul Mishra
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!