Changing value in cell

SarabSira

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

Paul Newcome

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))

SarabSira

@Paul Newcome Thank you for the suggestion. Will definitely try it out today and let you know how it goes. Regards