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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!