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
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})

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
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!