You need to sign in to do that
Don't have an account?
Marco Pollastri 1
picklist value countries
Hi, I am building a Process builder where I would like to create a formula that evaluates the country selected from the picklist Country on the lead object.
So my aim is to build this formula saying that if a country selected on the country picklist is China or Japan, then should trigger an action. How should I write the formula?
OR(
ISPICKVAL([Lead].Country, China),
ISPICKVAL([Lead].Country, Japan)
)
Thanks
So my aim is to build this formula saying that if a country selected on the country picklist is China or Japan, then should trigger an action. How should I write the formula?
OR(
ISPICKVAL([Lead].Country, China),
ISPICKVAL([Lead].Country, Japan)
)
Thanks
Not sure why you are using Type Formula you can select type as picklist andadd condition for both Picklist value. Choose Or condition for it
Something similar:
If it helps Please mark it as best Answer.
Thanks!
Try the below formula:
In Set conditions Operator ==> Equals , Type ==> Formula, Value ==> above Formula.
https://developer.salesforce.com/forums/ForumsMain?id=9062I000000DKg1QAG
Thanks,
Maharajan.C
You are missing the quotes around China and Japan.
Please try the below formula:
OR(
ISPICKVAL([Lead].Country, 'China'),
ISPICKVAL([Lead].Country, 'Japan'))
Hope this helps.
Regards,
Sandhya
Sandhya and Maharajan thanks for your help,
Unfortunately, i still receive the error message:
In Set conditions Operator ==> Equals , Type ==> Formula, Value ==> above Formula.
Add one more condition also to avoid nulls Field ==> [Lead].Country , Operator ==> Is null, Type ==> Boolean , Value ==> False.
Thanks,
Maharajan.C
Please use below formula in your process builder
if you need any assistanse, Please let me know!!
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh