Subtraction Formula

Buster Davis

Buster Davis ✭✭✭

07/21/23 in Formulas and Functions

Hello, I am trying to do a subtraction formula for below and replicate it across the remaining columns. I can't seem to find the subtract function in Smartsheet. Thoughts?

0 ·

Answers

Cory Page ✭✭✭✭✭

07/25/23

Good morning,
You should be able to use the Sum function hope this helps.
=SUM([R1]15- [R1]2)

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Next Expense Date Formula
I need to create a formula that will find the next expense date based off 3 other column categories. The columns and their categories are as follows: Due Date (single date when expense is due), Program ( Men, Women), and Budget Impact (Income, Expense). For this formula I need to find and return the next expense date from…
Automation Question around running on a Date field
I'm working on doing some cleanup on a smartsheet that had some extra columns/automation that I don't believe are in use. I have a question around how an automation uses dates, so i'll give what is probably unneccesary background. :-) For example, in our smartsheet there is a date field called CST Due for Info Update -…
Row with Multiple drop down choices and creating a summary
We have a Column on our Sheet which is a drop down list however more than one can be picked? Is there a way to as a summary to look for that field so that it sums it up? Below are 2 which are in a row and chosen from the drop down When we do the summary we would like this to be counted in both the IT Operations and Infra…