Contacts on multiple lines in a formula

I have a sheet that is organized by company and then a contact person per line. So it looks like

ABC Company John Smith Johnsmith@abc.com

ABC Company Tina Jones tinajones@abc.com


I want to write a formula in a different sheet that where I have ABC company, I can pull in both John and Tina's email addresses into one cell. Is this doable?

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Emily McNeeley

    Hope you are fine, please try the following formula:

    =JOIN(COLLECT({Email}, {Company}, [Column5]@row), " ; ")

    the following screenshots shows the result:

    the database sheet


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!