If function

IKatz101

Hello,

I'm happing trouble getting an if function correct as it keeps returning #unparseable. I have a nested if function in a contact type column. Depending on the value in the Service column of a row, it would return a specific email address. I have pasted the formula below although I've changed the email addresses for security purposes. Any help would be appreciated. Thanks in advance.

=if(or(Service@row="Smartsheet",Service@row="Emma"),email1@gmail.com,if(Service@row="Tableau",email2@gmail.com,if(or(Service@row="Zoom Webinar",Service@row="Large Zoom Meeting"),email3@gmail.com, email4@gmail.com)

Paul Newcome

You need quotes around each of the email addresses.

Paul Newcome

You need quotes around each of the email addresses.

IKatz101

That worked. Thank you!

Paul Newcome

Happy to help. 👍️