How do I add a formula to a column?

Alia

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?

IMG_5415.jpeg

Eric Law

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

Alia

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.

Eric Law

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.

Genevieve P.

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