How do I add a formula to a column?
I have added 3 new columns: “unit” , “subtotal High” , “SubTotal 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 subtotal it to the “SubTotal High” column. And the unit number will also multiply with the number in the “low” column and subtotal it to the “SubTotal Low” column. So how do I do that?
Answers

@Alia In you Subtotal High, your formula will be =Unit@row*High@row, same for the low, =Unit@row*Low@row

I would like to figure out formulas for more columns on my own. Can you tell me where there’s a tutorial on making formulas or a list of formulas that I can access? I am doing basic budget stuff. So most of it is addition and multiplication to determine subtotals and totals. Would appreciate a link or source where this formula information is please. fyi, I have no excel experience, so I am not a natural at this. Thanks.

You can do Smartsheet university, https://smartu.smartsheet.com/ and choose whichever course you want. There are some selfpaced course you can enroll in.

Hiya! Jumping in here to provide some extra resources, in addition to the University:
 The Formula Handbook template
 Free webinar: Formula Foundations
 Free webinar: Smartsheet Formula Best Practices
Help Article Resources
Categories
Check out the Formula Handbook template!