Skip to main content
Topics#Sales And MarketingPregunta de Shruthi GM
Shruthi GM ha preguntado en #Sales And Marketing
16 may 2019, 9:35

How to combine and write AND and OR condition in a formula

I have a requirement where I need to use both AND and OR conditions.

 

AND(

 

ISCHANGED([Contact].Owner.ProfileId),

 

OR(

 

CONTAINS($Label.ABC_Profiles, [Contact].Owner.Profile.Name),

 

CONTAINS("TEST Profile", [Contact].Owner.Profile.Name ) ),

 

NOT(CONTAINS([Contact].Account.Name,"XXX")),

 

NOT(CONTAINS([Contact].Account.Name , "YYY")), 

 

NOT(CONTAINS([Contact].Account.Name , "ZZZ")), 

 

[Contact].Account.Name <> "XYZ"

 

)

 

Here when the owner profile id is changed,and when the user logins with either of the one profile i,e ABC profiles or TEST profile and when account name not contains XXX,YYY,ZZZ a check box needs to be checked!

 

But formula is working only for Profile change condition and not for ABC and Test profile!!

 

Please help
3 respuestas
  1. Chris Duncombe (Imprivata)
    16 may 2019, 10:43
    Try this

     

     

    AND(
         ISCHANGED([Contact].Owner.ProfileId),
         NOT(CONTAINS([Contact].Account.Name,"XXX")),
         NOT(CONTAINS([Contact].Account.Name , "YYY")), 
         NOT(CONTAINS([Contact].Account.Name , "ZZZ")), 
         [Contact].Account.Name <> "XYZ",
         OR(
              CONTAINS($Label.ABC_Profiles, [Contact].Owner.Profile.Name),
              CONTAINS("TEST Profile", [Contact].Owner.Profile.Name )
         )
    )

     

     
Escribir una respuesta...
0/9000