Auto ID Vlookup Convert to Text

I have a column that is the "# Auto number" column generated within the selected Column types offered in one Smartsheet

I need to reference that # in 2d Smartsheet via VLOOKUP

I believe the VLOOKUP formula will not work because the generated "# Auto number" is in a text form and not a number value.

Please provide suggestion on how to do a VLOOKUP on "# Auto number" or to convert "# Auto number" to a number value

Find more posts tagged with

Accepted answers

All comments

CWS_Bob

Disregard ... I solved with the Value Function

Andrée Starå

Hi @CWS_Bob

I hope you're well and safe!

Excellent! Glad you go it working!

Be safe, and have a fantastic week!

Best,

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

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

insomnio23

Can you explain how this was solved?? I'm having the same situation, and I can't get the formula to work.

Genevieve P.

Hi @insomnio23

Can you post your formula and scenario so we can better help you?

The VALUE function mentioned above converts numbers that are appearing as text into numerical values, so you'd wrap that around the cell reference you want to ensure is coming through as a number.

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.