Bar code compatibility with Smartsheets
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!
Answers
-
Smartsheet does not recognize all barcode "languages".
-
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!
-
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?
-
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.
-
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?
-
Hi Paul,
Yes, I get the message "no results were found" ?
-
Are you starting and ending your barcodes with an asterisk when you are creating them?
-
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
-
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.
-
thank you so much for your help!
-
-
I've used this site for a couple of years to build Code-39 and Code-39 Full ASCII bar codes.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives