Auto ID Vlookup Convert to Text

CWS_Bob ✭✭✭
edited 03/11/23 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!