You need to sign in to do that
Don't have an account?
kjun
process builder formula evaluates to true
Is it possible to create a formula in process builder where:
Criteria:
Please let me know.
Thanks!
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!
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
AND(
[Lead].IsConverted = False,
OR(
[Lead].ActionOne__c = 1,
[Lead].ActionTwo__c = 2,
[Lead].ActionThree__c = 3
)
)
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?
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.