Multi Contact Column with Automations

Tony Oxa

Hi all,

I have a multi choice contact column that has a simple formula that looks at a country column and based on the country returns multiple emails per country, so lets say that column country is France i have the contact column return three contacts, so far it's fine but it doesn't work when i try to use an automation to send an email notification to the Contact column, seems like the Contact column its not recognizing the contacts. The formula is as follows:

=if([Country]@row="France","name.last@email.com,name.last@email .com,name.last@email .com",if([Country]@row="Italy","name.last@email .com,name.last@email .com,name.last@email .com",""))

Corey W.

@Tony Oxa I ran into this issue in the past myself with deriving multi contacts with functions and was not able to reliably fix it. It seems that Smartsheet doesn't always turn them into contacts.

What DOES work though, is using a helper sheet. In this sheet list your countries in one column and the multiple contacts in another. Then Index/Match or Vlookup the contacts using the country into your main sheet. Smartsheet does fine with moving multi-contacts between cells with functions, as long as they start out as actual contacts. The other advantage to this method is that you can easily make changes to your contacts in one place without having to fuss with editing functions.

Hope this helps. Good luck!