Bar code compatibility with Smartsheets

mrogers · 05/11/22

I'm trying to use the barcode scanning feature but the bar codes I am creating using excel are not recognized by the smartsheet phone app. Is there a specific format or bar code generator that I should use? Thank you!

Paul Newcome · 05/11/22

Smartsheet does not recognize all barcode "languages".

mrogers · 05/11/22

Thank you Paul! I've tried creating bar codes in excel but they aren't recognized - do you have a better bar code generator that you would recommend? Also, we will have people using both andriod and ios.

Appreciate your help!

Paul Newcome · 05/11/22

Take a look through the help center to find the barcodes recognized by ios. You should then be able to compare the two and find one that is common to both and can also be output by Excel.

I personally use Excel generated barcodes rather frequently with no issue. Are you getting an error message, or are you having some other kind of issue?

mrogers · 05/11/22

test bar code.jpg

Hi Paul,

Thanks for your patience - this is all new to me. I downloaded a "3 of 9" font for excel; it produced the attached image.

Paul Newcome · 05/12/22

I believe that is the same as Code39, so it should be usable. Are you getting an error message, or are you having some other issue?

mrogers · 05/12/22

Hi Paul,

Yes, I get the message "no results were found" ?

Paul Newcome · 05/17/22

Are you starting and ending your barcodes with an asterisk when you are creating them?

mrogers · 05/17/22

Hi Paul - this is the formula I'm using in excel. ="("&B3&")"; I used the instructions from the smartsheet online learning site. it produced this bar code

Paul Newcome · 05/17/22

Try replacing the parenthesis with asterisks. I can't remember exactly how I set mine up and can't seem to locate the original excel file (I printed it off and have it hanging in the shop). I read on an excel forum to use asterisks.

I am going to download the font again at some point and do some testing again. I just won't have time to do it today.