Adding & Subtracting in a row
I'm using this formula to total a row but I also need to subtract a column from the total of this formula. How can I had the column I need to subtract from the total?
=SUM([On Hand Inventory]@row, Received@row, Returned@row)
Best Answer
-
If your column to subtract is called Lost then your formula would be
=SUM([On Hand Inventory]@row, Received@row, Returned@row)-Lost@row
This will add up the values on the current row in the column On Hand Inventory, Received, and Returned and subtract the value in the Lost column.
Answers
-
If your column to subtract is called Lost then your formula would be
=SUM([On Hand Inventory]@row, Received@row, Returned@row)-Lost@row
This will add up the values on the current row in the column On Hand Inventory, Received, and Returned and subtract the value in the Lost column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!