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 [email protected]

ABC Company Tina Jones [email protected]

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!