Changing value in cell
Hi All,
I am new to Smartsheet so any help is appreciated. Currently trying to use multiple sheets/forms to record inventory by scanning a basic barcode. I have setup form entries to be duplicated in another sheet but the value of the barcode in numbers (ie: 407621031) needs to be recorded as the item name.
For example, I scan a barcode and it reads 407621031, this copies the row to another sheet where I can see a Makita Drill (Associated to that barcode) has been scanned and thus the sheet can record who has taken the tool and when etc.
Please provide a formula that can do this.
Many thanks
Answers
-
You would need to create a table that has the barcode numbers in one column and the tool name in another column. Then you would use an INDEX/MATCH to reference this table.
=INDEX({Tool Name}, MATCH(Barcode@row, {Barcode}, 0))
-
@Paul Newcome Thank you for the suggestion. Will definitely try it out today and let you know how it goes. Regards
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!