Changing value in cell

Hi All,

I am new to Smartsheet so any help is appreciated. Currently trying to use multiple sheets/forms to record inventory by scanning a basic barcode. I have setup form entries to be duplicated in another sheet but the value of the barcode in numbers (ie: 407621031) needs to be recorded as the item name.

For example, I scan a barcode and it reads 407621031, this copies the row to another sheet where I can see a Makita Drill (Associated to that barcode) has been scanned and thus the sheet can record who has taken the tool and when etc.

Please provide a formula that can do this.

Many thanks

Find more posts tagged with

Forms

Formulas

Accepted answers

All comments

Paul Newcome

You would need to create a table that has the barcode numbers in one column and the tool name in another column. Then you would use an INDEX/MATCH to reference this table.

=INDEX({Tool Name}, MATCH(Barcode@row, {Barcode}, 0))

SarabSira

@Paul Newcome Thank you for the suggestion. Will definitely try it out today and let you know how it goes. Regards

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.