Formula to Look Up Multiple Contact Columns
Hi There!
I am creating a formula that will assign contacts to a row based on user role plus some other attributes.
I am finding the look up is working great for assigning 1 contact, but when I extend the formula to include multiple v-look ups, its displaying the 2 users names as text. For example it will come back displayed as User1User2. The columns are set up to accept multiple contacts.
The formula I was trying is:
=VLOOKUP([Task Name]287, {Owners Range 1}, 4, false) + VLOOKUP([Task Name]288, {Owners Range 1}, 4, false)
Is there a particular delimiter i should use when adding multiple contacts to a cell using a formula?
Thank you!
Chad
Comments
-
Hello chadedwardconway,
Thank you for reaching out within Community
I have performed several tests with a various amount of formulas and can confirm that searching for two contacts using two different criteria is not possible, without it returning the contacts as text/string. It would appear that another user has experienced the same issue to no avail. (https://community.smartsheet.com/discussion/combine-two-separate-contact-cells-one-cell)
I will raise an Enhancement Request to our Product Team to consider this feature for a future release of Smartsheet. It's a great idea !
If you have any issues or questions, please let us know and we will be more than happy to assist you further.
Kind Regards
Sean
-
Is there an update on this formula/feature? This is a function I would like to use as well.
-
This would be soooo helpful. Please add this enhancment.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…
- Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
- I have a sheet that compiles all the responses from a form. The sheet has multiple start and end date columns, but only one start and one end date cell is NOT blank depending on the activity selected …