How to return a contact value when using IF

System

This discussion was created from comments split from: How to add multiple email addresses in a form field for email notification purposes?.

Catalin N

In the same topic as the responses above, what if I have a cell X (in a column) being a Contact list (as properties) and I having an If Condition, Then, Else formula that will automatically return in that cell multiple email addresses based on the Condition" of the If Condition, Then, Else function? How should be separated multiple emails so the Automation will consider these email addresses and execute the automation? Thank you!

Paul Newcome

@Catalin N There is no way to output multiple usable contacts from a formula like this. You will need to leverage one of the options outlined in the linked thread below:

https://community.smartsheet.com/discussion/123433/combine-emails-into-a-multiple-contact-column-multi-contact-column