Sum of column when moving rows
When I move rows to a destination sheet, I need to have a running sum of one particular column as each row is added.
I've tried doing a sum of children (but the moved row comes in at the wrong position) or just an auto sum at the top of the sheet but when new rows are added, they don't get summed.
Is there an easy way to accomplish this?
Best Answer

=SUM([Column 2]:[Column 2])
This will only work if you put the formula in a different column. In my example, the formula is in Column 1 and adding up all the values in Column 2
Alternately, you could put the same formula in the sheet summary and you wouldn't have to add the new column.
Answers

=SUM([Column 2]:[Column 2])
This will only work if you put the formula in a different column. In my example, the formula is in Column 1 and adding up all the values in Column 2
Alternately, you could put the same formula in the sheet summary and you wouldn't have to add the new column.

Thank you!
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!