How to update available qty on an inventory tracker?
Hi!
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?
THANKS
Best Answer
-
You would do something along the lines of...
[Stock @ Start]@row + SUMIFS({Reorder Sheet QTY Column}, {Reorder Sheet SKU Column}, @cell = [Item SKU]@row) - SUMIFS({Sold Sheet QTY Column}, {Sold Sheet SKU Column}, @cell = [Item SKU]@row)
Answers
-
You would do something along the lines of...
[Stock @ Start]@row + SUMIFS({Reorder Sheet QTY Column}, {Reorder Sheet SKU Column}, @cell = [Item SKU]@row) - SUMIFS({Sold Sheet QTY Column}, {Sold Sheet SKU Column}, @cell = [Item SKU]@row)
-
Thank you!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!