Formula to Look Up Multiple Contact Columns

chadedwardconway

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

Sean Morgan

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