Inventory Automation - How to subtract cell data from one sheet to another by matching SKU#
I would like to subtract the quantity from my "Inventory Pull Log" from my "Inventory Sheet", how would I go about doing this?
This is the Inventory Sheet where I would like the subtraction to take place:
And this is the sheet that I would like to reference to subtract the quantity from:
Best Answer
-
My apologies. I didn't realize you were putting it in the same Qty column. My suggestion would be to insert another column (that can later be hidden). This column will contain a "Starting Quantity". Then you would replace
Quantity@row
with
[Starting Quantity]@row
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
The syntax for your SUMIF is off, and you don't need the MATCH function.
=Quantity@row - SUMIF({Other Sheet SKU#}, [SKU#]@row, {Other Sheet Quantity Column})
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Paul,
Thanks for the quick response! I've added that formula but looks like I'm getting a circular reference?
-
Paul,
Thanks for the quick response! I've added that formula but looks like I'm getting a circular reference?
-
My apologies. I didn't realize you were putting it in the same Qty column. My suggestion would be to insert another column (that can later be hidden). This column will contain a "Starting Quantity". Then you would replace
Quantity@row
with
[Starting Quantity]@row
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 306 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!