Total column formula vs in cell formula?
Kohl W
✭✭
I have a table set up to calculate total revenue for an entire column but I also want it to be auto calculating for the cell as the contract amount will be updated frequently with change orders. So I have original contract amount + change order amount should equal total contract amount. The total contract amounts are being calculating for the entire column but how I can formulate so I am not manually inputting the updating total contract amounts?
Answers

@Kohl W The cells where you want to have the total for the entire column, is it a parent row? or do you have some kind of differentiator you can use in another column as the catalyst on whether to total the entire column or total the contract amount + change order amount?

This is a snipped of the columns. The revised contract is what I am trying to write a formula to auto compute adding the original contract and approved column.

Hi @Kohl W ,
Something like this should work.
=[\[$\] Original Contract]@row + [\[$\] Approved Change Orders]@row
Hope this helps,
Dave
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 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!