How do I add a formula to a column?

I have added 3 new columns: “unit” , “sub-total High” , “Sub-Total Low”. See attached screenshot, their titles are in grey. Each time I add a unit, I want it to multiply that number with the number in the “high” column, and sub-total it to the “Sub-Total High” column. And the unit number will also multiply with the number in the “low” column and sub-total it to the “Sub-Total Low” column. So how do I do that?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!