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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!