Contacts on multiple lines in a formula

Emily McNeeley
Emily McNeeley ✭✭✭✭✭
in Formulas and Functions

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?

· Share on FacebookShare on Twitter

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:

    image.png

    the database sheet

    image.png


    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"

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!