Bar code scanner not capturing actual bar code only numbers/text

kristian.jochimsen

I am trying to build an inventory/stock management sheet but i cannot scan the actual bar code image into the sheet.

I have tried using an Iphone XR and a Samsung Galaxy S9 with no luck on wither.

It will only scan the numbers and/or text. I have tried over ten different bar codes on various items with no luck.

Please help. This is a major hurdle.

Thanks very much,

Kristian Jochimsen

Find more posts tagged with

Attachments

Project Management

Comments

Andrée Starå

Hi Kristian,

Unfortunately, it's not possible at the moment to add barcode pictures by scanning, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

As a workaround, you could use a Google Sheet solution to create the barcode images and then add those to Smartsheet.

Would that work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

I have a "master inventory" sheet of sorts, and I simply attached a picture of the barcode in a column I just called "Barcode".

Andrée Starå

Yes, you can, of course, take a picture of the barcode and save that, but I think what's asked for is probably a clean barcode picture.

Good workaround nevertheless!

kristian.jochimsen

Thank all.

I will figure out a solution one way or another.

Andrée Starå

Happy to help!

Have a fantastic weekend!

Paul Newcome

Happy to help!

Paul Newcome

Yes. Having the "clean" barcode displayed on the sheet would be nice. To keep things looking half decent, I have to crop and resize each of my images to make sure all of the barcodes appear to be the same size and whatnot. I ended up getting the most consistent results using the barcode "font" in Excel then using the cell outline as a guide for a snippett. My snippetts save as .png files, so I am able to easily display them in a cell in SS from there.

Andrée Starå

It's possible to automate it with the help of Goggle Sheets so you don't have to crop any pictures.

Paul Newcome

I'm going to have to dig into this. While my current system is working pretty smoothly, everything that can be automated is one less thing that I have to worry about forgetting.

Andrée Starå

Exactly!

I'll share if I find have something that you could use.

Paul Newcome

Much obliged!!

Andrée Starå

Here's an excellent resource.

https://berrywing.com/barcode/

Andrée Starå

Here's what you could use to get an EAN 128 code in Google Sheet.

=image("http://berrywing.com/barcode/Code128.aspx?bc=" & A1)

Paul Newcome

Awesome! I'll take a look.

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…