You need to sign in to do that
Don't have an account?
Stephen02
Formula for multiple OR conditions for Workflow Rule
Hi - I have a need for a formula with multiple OR conditions in a Workflow rule
For example,
IF (Preferred_Language__c does NOT equal English, or Spanish, or French, or Mandarin
THEN
(update field called Let_Template to English)
Thank you.
For example,
IF (Preferred_Language__c does NOT equal English, or Spanish, or French, or Mandarin
THEN
(update field called Let_Template to English)
Thank you.
Try this
OR( TEXT(Field1) = "Yes", TEXT(Field2) = "Yes", TEXT(Field3) = "Yes", TEXT(Field4) = "Yes", TEXT(Field5) = "Yes", TEXT(Field6) = "Yes", TEXT(Field7) = "Yes", TEXT(Field8) = "Yes", TEXT(Field9) = "Yes", TEXT(Field10) = "Yes" )
In this example, I am assuming that Preferred_Language__c is a text field. If it is a picklist, rewrite the conditions within the OR group using ISPICKVAL or TEXT.
Hope this helps.