How to write a running total in a list

kbernard

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!

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.