=upca Barcode Font Encoder

Pelowtz

Hey!

I need to create UPCa text strings in Smartsheet. 

Currently we are using an excel spreadsheet that converts number strings into UPCa font values using an excel VBA macro. 

When I imported my Excel file into smartsheet, this macro was not imported, so the barcode creation functionality is now missing. 

Does Smartsheet have a way to convert numbers into UPCa fonts?

Here's a reference to a similar excel Add-In that essentially does what I'm describing. 

https://support.idautomation.com/Font-Encoders/How-to-create-UPC/EAN-barcodes-in-Excel-using-VBA/_2781

To clarify further, the macro converts a number string like this:

809801931052

Into a text string that our designers can use to create barcodes using a font. The output looks like this:

x(i09801*TMKRQq(v

 

Thanks for any info. 

 

 

J. Craig Williams

I don't know what the macro does. If is just a formula, which I assume, then it would be possible.

Smartsheet does not have a scripting language or iterable formula.

Craig