Does Smartsheet integrate well with any barcode generators?

I'm heading the inventory control department at our lab and we'll need to be able to track parent and child samples throughout the lab via scanning them at which ever work station they happen to be at. Any recommendations for a good barcode generator that works well within Smartsheets would be appreciated!

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi@Handersen

    I hope you're well and safe!

    Here are some QR code resources.

    I've also used Google Sheets to create QR Codes.

    • I developed a client solution recently with a structure in Smartsheet for each manufacturing step and then pasted those codes into a Google Sheet to create the QR Codes for print.(formatted for labeling or to put in a binder)

    Would any of those options work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    我的帖子(s) help or answer your question or solve your problem? Please support the Community bymarking 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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the公式手册模板!
That worked perfectly, thank you!!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109369,"type":"question","name":"INDEXING and Validating","excerpt":"I have a perplexing question, that I am sure someone knows and I am missing here. I am working on a sheet to gather data from a form. However, this form will get quite lengthily and may span multiple years. With that said this is where I am stumped. =INDEX(COLLECT({Test Sheet 1 Range 1}, {Test Sheet 1 Range 1}, <> \"//www.santa-greenland.com/community/discussion/97456/\"),…","snippet":"I have a perplexing question, that I am sure someone knows and I am missing here. I am working on a sheet to gather data from a form. However, this form will get quite lengthily…","categoryID":322,"dateInserted":"2023-08-23T21:21:49+00:00","dateUpdated":null,"dateLastComment":"2023-08-24T14:04:04+00:00","insertUserID":163519,"insertUser":{"userID":163519,"name":"Frank Hammond","title":"Mr.","url":"https:\/\/community.smartsheet.com\/profile\/Frank%20Hammond","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2023-08-24T15:23:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":163506,"lastUser":{"userID":163506,"name":"JamesB","title":"IT Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/JamesB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nEQMY42MFGXWS.png","dateLastActive":"2023-08-24T14:09:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":28,"score":null,"hot":3385713353,"url":"https:\/\/community.smartsheet.com\/discussion\/109369\/indexing-and-validating","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109369\/indexing-and-validating","format":"Rich","lastPost":{"discussionID":109369,"commentID":392314,"name":"Re: INDEXING and Validating","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392314#Comment_392314","dateInserted":"2023-08-24T14:04:04+00:00","insertUserID":163506,"insertUser":{"userID":163506,"name":"JamesB","title":"IT Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/JamesB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nEQMY42MFGXWS.png","dateLastActive":"2023-08-24T14:09:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-23T21:50:04+00:00","dateAnswered":"2023-08-23T21:43:36+00:00","acceptedAnswers":[{"commentID":392246,"body":"

@Frank Hammond<\/a> <\/p>

Your formula is close, looks like you just need commas between your criterion range and criterion.<\/p>

=INDEX(COLLECT({Test Sheet 1 Range 1}, {Test Sheet 1 Range 2}, = 9, {Test Sheet 1 Range 3}, = 2023), Index@row)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":109368,"type":"question","name":"CountIFs referencing multiple columns, one of which is multi-select","excerpt":"I am trying to do COUNTIFS with multiple criteria\/columns, referencing another sheet. Essentially, I need a Count of if the items meet the following criteria: Were created in X Month (text column) Were created in X Year (text column) AND a multi-select column contains \"North America\" I have my formula partially down, but…","snippet":"I am trying to do COUNTIFS with multiple criteria\/columns, referencing another sheet. Essentially, I need a Count of if the items meet the following criteria: Were created in X…","categoryID":322,"dateInserted":"2023-08-23T21:05:41+00:00","dateUpdated":"2023-08-23T21:06:24+00:00","dateLastComment":"2023-08-24T13:24:46+00:00","insertUserID":156894,"insertUser":{"userID":156894,"name":"Jessica Z","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Z","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bam1G8UgVDg!n-mxX59l_jw!vKSG4USd3sh","dateLastActive":"2023-08-24T13:23:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":156894,"lastUserID":156894,"lastUser":{"userID":156894,"name":"Jessica Z","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Z","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bam1G8UgVDg!n-mxX59l_jw!vKSG4USd3sh","dateLastActive":"2023-08-24T13:23:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":32,"score":null,"hot":3385709427,"url":"https:\/\/community.smartsheet.com\/discussion\/109368\/countifs-referencing-multiple-columns-one-of-which-is-multi-select","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109368\/countifs-referencing-multiple-columns-one-of-which-is-multi-select","format":"Rich","lastPost":{"discussionID":109368,"commentID":392307,"name":"Re: CountIFs referencing multiple columns, one of which is multi-select","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392307#Comment_392307","dateInserted":"2023-08-24T13:24:46+00:00","insertUserID":156894,"insertUser":{"userID":156894,"name":"Jessica Z","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Z","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bam1G8UgVDg!n-mxX59l_jw!vKSG4USd3sh","dateLastActive":"2023-08-24T13:23:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-24T13:23:55+00:00","dateAnswered":"2023-08-23T21:10:03+00:00","acceptedAnswers":[{"commentID":392237,"body":"

@Jessica Z<\/a> How were you using the HAS function?<\/p>

Try this:<\/p>

=COUNTIFS({RPA Client Catalog Month}, \"January\", {RPA Client Catalog - Year Bot WL}, \"2023\", {RPA Client Catalog - Region}, has(@cell, \"North America\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Formulas and Functions