Is there a formula where anytime I scan a barcode it subtracts from the Quantity on hand value?
Tyoung
✭✭
Answers
-
You'd create one sheet that you scan all barcodes into.
Then you'd create another sheet which has all SKUs in inventory and has a COUNTIF formula to count the instances of that SKU # being on the other sheet with all the scanned barcodes. You'll also need your baseline inventory count for what your starting quantity is for the COUNTIF to take away from that.
Then on the sheet in your picture you'd vlookup or index match the sheet with the COUNTIF formulas.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!