Workflow "From" expression
I'm trying to build an expression to select the correct "from" email based on a person's role:
IIf(JoinFieldValue('<Contact>',[<KeyContactId>],'<AlternateCountry>')='USA','IT@k2m.com', (IIf(JoinFieldValue('<Contact>',[<KeyContactId>],'<AlternateCountry>')=('Argentina' OR 'Barbados' OR 'Brazil' OR 'Canada' OR 'Chile' OR 'Colombia' OR 'Ecuador' OR 'Guatemala' OR 'Mexico' OR 'Peru')),'sales@k2m.com', 'HR@k2m.com'))
Basically, if the Primary Contact's country (related to the Opportunity) is...
USA, have the workflow e-mail be from IT
From any of the countries listed, have the workflow email from Sales