Add multiple contacts to one column?

CNaenfeldt

Hello,

Is there a way to add both emails directly to one column from the reference sheet? When I try I only get #INCORRECT ARGUMENT.

As you can see sometimes it happens that I don't have two names in one cell:

Current formulas that are working for individual emails, depending on if the name is before or after the ", ".

=INDEX({Email}, MATCH(LEFT(Names@row, FIND(", ", Names@row) - 1), {Email Names}, 0))

=INDEX({Email}, MATCH(RIGHT(Names@row, (LEN(Names@row) - FIND(", ", Names@row) - 1)), {Email Names}, 0))

Thank you!

jmyzk_cloudsmart_jp

Hi @CNaenfeldt

You can use the COUNTM() function to get the number of elements of multiple-select dropdown lists or contacts.

https://help.smartsheet.com/function/countm

Then, if the COUNTM() =2, use your two formulas. If the COUNTM() is 1, set the second email as "".

To combine two emails to Email(s), use a formula like this.

=[email 1]@row + "," + [email 2]@row

https://app.smartsheet.com/b/publish?EQBCT=858a6fdfd0844a6d991dd7e5c4ef636e

Again, if the COUNTM() is 1, return just the first email.

If you have many (N) emails, you can use JOIN(Email1:EmailN,",") and use SUBSTITUTE() to remove the last "," by a formula like SUBSTITUTE(join-result-text, "last email, ", "last email").

Paul Newcome

You would need to use the API if you are wanting to output email addresses that are usable for Automations.

There is currently no way to use a formula to output multiple USABLE contacts in a single cell.