I am currently setting up an inventory management sheet that has a webform. I want to be able to have data updated based on one column.
What I have is a column that is Shipped / Received.
When completing the form, if the user chooses Shipped, the QTY column displays -10 and then takes this away from total stock on hand. If they choose Received, it displays as 10 and adds this to the stock on hand.
What would be the formula to have for the QTY column to display this based on the Shipped / Received column.
Thanks in advance