Contact Column VLOOKUP Not Generating Contact
Hello Smartsheet community,
I am having a small struggle with a contact column in one of my sheets. I have a formula:
=IFERROR(IF(FDO@row < TODAY(), VLOOKUP([Store Number]@row, {Setup and IT Completed Range 1}, 14, false), VLOOKUP(Location@row, {Setup and IT Dates Range 1}, 13, false)), "")
The column it is referencing for the VLOOKUP is a Contact Column type. The column the formula is in is also a contact list. I would like that if the date (FDO) is in the past, pull a contact from Setup and IT Completed Range 1 and if the date is in the future, pull a contact from Setup and IT Dates Range 1. Instead, however, it is pulling rich text and not the actual contact in our account. Any ideas why it may not be pulling the actual contacts? Thanks!
Best Answer
-
I feel so very silly. One of the columns had "Multiple contacts" enabled and that was breaking the formula. Always check your settings folks!
(I can't delete the actual post, so, hopefully if anyone else ever runs into this issue they'll see my comment and check their column settings)
Answers
-
I feel so very silly. One of the columns had "Multiple contacts" enabled and that was breaking the formula. Always check your settings folks!
(I can't delete the actual post, so, hopefully if anyone else ever runs into this issue they'll see my comment and check their column settings)
-
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.
-
Thank you Jennifer! I was having the same problem and your answer was very helpful.
-
@Ryan Lancaster I'm glad it was helpful! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!