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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 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!