Subtraction formula

Options

Byrdtn

Byrdtn ✭✭

03/13/23 in Formulas and Functions

Hello,

I created a sheet for keeping track of invoices and the amount that is left. I am having trouble trying to figure out how to do a subtraction formula to reflect the amount that is remaining.

Screenshot 2023-03-13 141635.png

0 ·

Answers

Jeff Reisman Community Champion

03/13/23

@Byrdtn
Have you tried this in the Remaining Funds column?
=[Starting Invoice Amount]@row - [Total Amount Paid]@row

Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
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

Formula VLOOKUP or maybe an alternative solution
Hello, I am trying to develop a formula that will reference another sheet and bring back the content from a specific cell. Need to reference two columns for the match in the reference sheet. The match component will come from a column [PI or Account #] on the main sheet to be searched in column 1 on reference sheet and…
Concatenate Formula in SmartSheet
I am in the process of migrating workbooks from Excel to SmartSheet, but am having trouble with the Concatenate formula. I have a column of store numbers and am trying to automatically create the store manager email to be used across different sheets, but I cannot use the concatenate formula in SmartSheet the same way as…
Text to populate when Box is Checked
I need to populate text in a cell when there is a box checked anywhere within a row. This is what I came up with, but it isn't working =IF([Weekend Travel:WeekendTravel]@row = 1, "Weekend Stay")