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

  • parulmishra
    parulmishra ✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!