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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!