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
-
@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 sub-totals 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 self-paced 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!