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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!