Barcode font or formula

Adilson Mota

Hello I'm Adilson Mota

I'm create the Smartsheet to use in the production but he next step to implement the scanner employer barcode, work station barcode and stop production barcode, but I need help to transform the code in barcode and scanner the production line.

I attached the example in the excel, but a could like to implement in my Smartsheet the same idea.

Could you

Barcode Production.xlsx

help me about it transform de code in barcode in my Smartsheet? 

Paul Newcome

You will need to have a barcode font downloaded onto your computer. From there you can select it as a font in Excel.

https://answers.microsoft.com/en-us/msoffice/forum/all/barcode-fonts/ac2c3a0b-35b5-4576-83dc-28626d56f915

Adilson Mota

Hello Paul

Thanks very much about your answer but isn't successful because the Smartsheet accept only 4 fonts like attached.

Could you have another way in how to add these barcode Font?

Actual Font Smartsheet.PNG

Paul Newcome

You cannot generate the barcodes in Smartsheet. You would download the font to your computer and use Excel to generate the barcode. The scanning option in the Smartsheet App on mobile devices can read the barcode and will output whatever letters/numbers that barcode represents.

Adilson Mota

Ok Paul Thanks very much.

Have a nice week.

Andrée Starå

Hi @Adilson Mota

I hope you're well and safe!

To add to Paul's excellent advice/answer.

I recently developed a solution for a client using Google Sheets. In short, I have a project task structure in Smartsheet and in Google Sheets, and I copy a pattern into a field in Google Sheets, which creates all labels that link to pre-filed Smartsheet forms to submit specific task/time information.

It can probably work automatically using Zapier or a similar 3rd-party solution.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!