+ Start a Discussion
kjunkjun 

process builder formula evaluates to true

Is it possible to create a formula in process builder where: 

Criteria: 
 
[Lead].IsConverted = False (Boolean)
and
[Lead].ActionOne__c = 1
or
[Lead].ActionTwo__c = 2
or
[Lead].ActionThree__c = 3

Action: 
MyAction__c = False (Boolean)
I'm looking for the criteria formula part. 

Please let me know. 

Thanks!

 
Best Answer chosen by kjun
Danish HodaDanish Hoda
If your fields - ActionOne__c, ActionTwo__c, ActionThree__c are picklist fields, the formula would be :
AND(
[Lead].IsConverted = False,
OR(
TEXT([Lead].ActionOne__c) = "1",
TEXT([Lead].ActionTwo__c) = "2",
TEXT([Lead].ActionThree__c) = "3"
)
)

Please mark this answer as Best, if it works for you.

All Answers

Danish HodaDanish Hoda
Yes, you can create formula like :

AND(
[Lead].IsConverted = False,
OR(
[Lead].ActionOne__c = 1,
[Lead].ActionTwo__c = 2,
[Lead].ActionThree__c = 3
)
)
kjunkjun

I receive this error message: 

 

The formula expression is invalid: Field Lead is a picklist field. Picklist fields are only supported in certain functions.

Also, my picklist values are text not numbers, would that be the reason? 

Danish HodaDanish Hoda
If your fields - ActionOne__c, ActionTwo__c, ActionThree__c are picklist fields, the formula would be :
AND(
[Lead].IsConverted = False,
OR(
TEXT([Lead].ActionOne__c) = "1",
TEXT([Lead].ActionTwo__c) = "2",
TEXT([Lead].ActionThree__c) = "3"
)
)

Please mark this answer as Best, if it works for you.
This was selected as the best answer