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
Help Article Resources
Check out the Formula Handbook template!