Inventory Automation - How to subtract cell data from one sheet to another by matching SKU#

Jimrny · 08/11/21

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:

Paul Newcome · 08/11/21

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

Paul Newcome · 08/11/21

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

Jimrny · 08/11/21

Paul,

Thanks for the quick response! I've added that formula but looks like I'm getting a circular reference?

Jimrny · 08/11/21

https://community.smartsheet.com/discussion/comment/301007#Comment_301007

Paul,

Thanks for the quick response! I've added that formula but looks like I'm getting a circular reference?

Paul Newcome · 08/11/21

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

Inventory Automation - How to subtract cell data from one sheet to another by matching SKU#

Best Answer

Answers

Help Article Resources

Categories