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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!