Total column formula vs in cell formula?

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!