How to update available qty on an inventory tracker?


I'm creating an inventory tracker and I want the "ITEMS AVAILABLE" column to keep updating as we reorder and sell items. I'm also creating two apps in AppSheet, one to make orders to suppliers and another to sell items, so both "ITEM REORDER QTY" and "SOLD ITEMS" column's values will come from other sheets which contains a log of all orders and sells made. How can I make the "ITEMS AVAILABLE" column show ("STOCK @ START" + "ITEM REORDER QTY" - "SOLD ITEMS") without forgetting/deleting the previous amount?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!