Add multiple contacts to one column?

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!