Subtraction formula
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.
Answers
-
Have you tried this in the Remaining Funds column?
=[Starting Invoice Amount]@row - [Total Amount Paid]@row
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
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!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!