How to return email addresses for multiple contacts in a cell?

I have a column name Project Sponsor/ Owner with multiple contacts in the cell. In another column I have Project Sponsor Contact, which returns the email address for the sponsor. I created a VLOOKUP formula and it only found the email for one contact in the cell, but not emails for multiple contacts. What logic do I use to return multiple email addresses for one cell that has more than two names in it?



Answers

  • Hi @Tab

    Currently formulas can't parse out a multi-select field to search for each individual contact within a reference table as separate values; your VLOOKUP reference table would need to have a column with all possible combinations for the formula to find a match. This is why if a cell only has one contact listed it can find a match.

    Please let the product team know of your feedback on multi-contact columns and formulas by filling in this form, here!

    Thanks,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!