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
-
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
☑️ 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
-
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
☑️ 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"
-
@Bassam Khalil Thank you!
-
You are welcome.
☑️ 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"
Help Article Resources
Categories
Check out the Formula Handbook template!
