Smartsheets and Barcodes

Hey all,

I recently followed the guide Smartsheet has posted on their site: https://www.smartsheet.com/content/excel-barcodes but I've reached a point where I'm stuck.

I downloaded the appropriate fonts and got the barcodes to show up on the excel file, but when I input into Smartsheet, the data in the barcode column comes back as "#UNPARSEABLE". I looked for alternative solutions where I could just populate the barcode column with an image of the barcode derived from excel, but the "Picture" function is greyed out on my phone when I access the sheet from there.

I have the excel generated barcodes printed out (Code 39) but Smartsheet doesn't recognize them and I can't find a function to input the image into the "Barcode" tab for reference. Any ideas?

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @biotechguy

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to 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!

biotechguy

Excel_Barcodes.PNG

Smartsheet_Barcodes.PNG

Hi Andree,

Thank you for your response, I've attached two snips of what I am trying to do. The "Excel" picture has the barcode formula with the Code39 font and the "Smartsheet" picture is what it looks like when I input the file over.

Emily Zeiger

I had the same trouble - I switched to QR codes in excel using the QR code tracker add in and it has been able to successfully scan in the codes now.

Also - there is an option on the mobile app to scan the barcode, not take an image, that was more helpful to me. I ran out of assistance in the smartsheet documentation but ended up finding this video that made it much easier for me to understand. How to Use Barcode Scanning in Smartsheet | Inventory Solutions Template in Smartsheet | Mobile App - YouTube

TaceyB

The mobile app is not scanning a bar code. From reading multiple threads, it seems this is not working for many people. What is the status of this functionality?

MaaikMeijerink

hi @biotechguy,

Already looked at

https://www.smartsheet.com/marketplace/apps/inline-qr-generator?srsltid=AfmBOopoU_W0NMrFKXZYwlf9kXwdHoQaKMWy5DKqplOnr2pnsbQtWPpK ?

Perhaps this can solve (part of) your challenge?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.