How to write a running total in a list
Options
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!