Subtraction formula

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

Counting occurrences of values in a multi-select dropdown list
I have looked through all of the answers for this topic, and still cannot find a solution that works for me. I have a sheet with a multi-select dropdown used to code responses. In another sheet, I want to count the number of times a certain value appears in any dropdown in the sheet column. Here is my formula:…
How would I write a formula to locate duplicates in 1 column and the difference in another column.
I have 1 sheet that has duplicated Classroom IDs but different scores on each line. I need to flag any instances during the same term of a difference over 1.00 higher or lower with the same Classroom ID. I need to find the repeat instances within column "Classroom ID" that occur during the same Column "Term Name" and then…
#NO MATCH result but not for identical formulas
I have two formulas that are fairly identical but one is producing a #NO MATCH error. =COUNTIFS(Shop:Shop,Shop@row,[Review Start Date]:[Review Start Date], YEAR(@cell)= YEAR([Review Start Date]@row)) This works just fine and returns the proper counts. The Shop column is a number/text field - and the Review Start Date is a…