Running Total
Hi,
I am quite new to Smartsheets and trying to set up a running total on a sheet that adds up the ongoing numbers input into another column. I have looked at some of the other posts on this topic
but cannot seem to get mine to work. I have input the totals manually to show what I am after. Help!
Best Answers

Hello @Chard,
I came up with two possible solutions, one more simple, and one more complex (but better in the long run).
1.The first method finds the total sum of the cell above it and the new quantity added to that row, and you drag the formula down like you would in excel:
2. The second method requires an ongoing row number helper column, but the running total is autocalculated and less prone to breaking:
The first thing you'll want to do is make the row number column —the row number formula does still need to be manually dragged down to new rows, and can go beyond the data as it counts if cells are both blank or populated.
Once that is done, the running total will autocalculate using the row number column, and can be converted to a column formula so you never have to edit it again.
Row Number:
=COUNTIFS([Quantity Made]$1:[Quantity Made]@row, OR(ISBLANK(@cell ), NOT(ISBLANK(@cell ))))
Running Total:
=IF([Quantity Made]@row = 0, "", SUMIFS([Quantity Made]:[Quantity Made], [Row Num]:[Row Num], @cell <= [Row Num]@row))
I hope this helps!
Renée Roberge

You can make the row number formula a column formula by starting with an autonumber type column and then using this column formula in a text/number column:
=MATCH([AutoNumber Column Name]@row, [AutoNumber Column Name]:[AutoNumber Column Name], 0)
Answers

Hello @Chard,
I came up with two possible solutions, one more simple, and one more complex (but better in the long run).
1.The first method finds the total sum of the cell above it and the new quantity added to that row, and you drag the formula down like you would in excel:
2. The second method requires an ongoing row number helper column, but the running total is autocalculated and less prone to breaking:
The first thing you'll want to do is make the row number column —the row number formula does still need to be manually dragged down to new rows, and can go beyond the data as it counts if cells are both blank or populated.
Once that is done, the running total will autocalculate using the row number column, and can be converted to a column formula so you never have to edit it again.
Row Number:
=COUNTIFS([Quantity Made]$1:[Quantity Made]@row, OR(ISBLANK(@cell ), NOT(ISBLANK(@cell ))))
Running Total:
=IF([Quantity Made]@row = 0, "", SUMIFS([Quantity Made]:[Quantity Made], [Row Num]:[Row Num], @cell <= [Row Num]@row))
I hope this helps!
Renée Roberge

You can make the row number formula a column formula by starting with an autonumber type column and then using this column formula in a text/number column:
=MATCH([AutoNumber Column Name]@row, [AutoNumber Column Name]:[AutoNumber Column Name], 0)

Hi @rrenee, Thank you so much for your help on this. Used both, and worked a treat! 😀
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!