Auto ID Vlookup Convert to Text

CWS_Bob

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

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.