Number to Text Formula

Cristian Rangel · 01/09/20

hello everyone,

i am trying to create a formula that will take a series of numbers (UPC) and convert them into a text. I am currently trying to implement the barcode scanner to a form.

ex: on the form, i will scan the product/equipment, and as i submit the form, the sheet will convert it to a text designated to that number/UPC.

is this possible?

it would also be beneficial if i could create another column to the left/right of the number that will have an equation tied to it to convert the number column to text.

any advice would be greatly appreciated!

Andrée Starå · 01/09/20

Hi Cristian,

Yes, it's possible!

You'd use an VLOOKUP or INDEX/MATCH combination of formulas.

https://help.smartsheet.com/function/vlookup

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Would that work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 01/09/20