Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

calculate a running total from updated cells

Paul Johnson
edited 12/09/19 in Archived 2016 Posts

I have a spreadsheet which tracks the order process .

A simple dropdown list qualifies a cell as either "quoted" or " PO received".

Once that cell has changed to "PO received"  I'd like to deduct the qty for that order from "stock in warehouse" so That I can see at a glance how much available stock I have.

Is there a formula I can use that checks a cell in a row by its identifier and subtracts its adjacent cell " QTY on order " from my " stock in warehouse"  Any Ideas?



  • Greg Gates
    Greg Gates ✭✭✭✭✭

    You sure can! This is what the "SUMIF" formula is for. I imagine your formula would look something like this:


    =[Warhouse Stock]1 - SUMIF([PO Status]:[PO Status], "PO Received", [QTY On Order]:[QTY On Order])


    I hope that helps! I'm just guessing at your column names, so let me know if you have any questions or if it didn't solve your problem.

  • Hi Gregg, that's perfect , worked a treat. Thanks for the prompt reply 

This discussion has been closed.