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
Answers
-
Disregard ... I solved with the Value Function
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Can you explain how this was solved?? I'm having the same situation, and I can't get the formula to work.
-
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.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!