You need to sign in to do that
Don't have an account?
Marion Sibbe
validation rule - If one of the picklist vlaues is selected, another picklist will be mandatory
Hi all,
I need some help with a validation rule please.
I have the picklist "Network" with 30 Values. For 20 of them it is necessary to enter another information in the picklist field "Payment".
I tried different ways, but I was only able to relate one value to the the 2nd picklist. But this I also can not reproduce anymore. Can you help me? I played with AND and OR ...but it won't work :(
Last try is:
AND(
ISPICKVAL(network__c,"AD"),
ISPICKVAL (network__c,"AX"),
(ISBLANK(Payment_Type__c)))
In this case I got the Error "Error: Field Affiliate_Payment_Type__c is a picklist field. Picklist fields are only supported in certain functions. " But before it worked with the field. i have no idea..
I need some help with a validation rule please.
I have the picklist "Network" with 30 Values. For 20 of them it is necessary to enter another information in the picklist field "Payment".
I tried different ways, but I was only able to relate one value to the the 2nd picklist. But this I also can not reproduce anymore. Can you help me? I played with AND and OR ...but it won't work :(
Last try is:
AND(
ISPICKVAL(network__c,"AD"),
ISPICKVAL (network__c,"AX"),
(ISBLANK(Payment_Type__c)))
In this case I got the Error "Error: Field Affiliate_Payment_Type__c is a picklist field. Picklist fields are only supported in certain functions. " But before it worked with the field. i have no idea..
You need to use a CASE function when you have to compare multiple values against a single field. Your formula will be like this.
You just have to enter the other 18 values in the same format that I used for the AD and AX values.
Kindly mark it as an answer if it works so that we can close the thread.
All Answers
OR(
ISPICKVAL(network__c,"AD"),
ISPICKVAL (network__c,"AX"),
AND (ISBLANK(Payment_Type__c)))
ISPICKVAL(network__c,"AD"),
ISPICKVAL (network__c,"AX")),
AND (ISBLANK(Payment_Type__c))
Syntax error. Extra ','
If I delete it, i am getting
Syntax error. Extra AND...
I don't get it :-o
ISPICKVAL(network__c,"AD"),
ISPICKVAL (network__c,"AX"))
AND (ISBLANK(TEXT(Payment_Type__c)))
You need to use a CASE function when you have to compare multiple values against a single field. Your formula will be like this.
You just have to enter the other 18 values in the same format that I used for the AD and AX values.
Kindly mark it as an answer if it works so that we can close the thread.
Thank you so much Akhil :)
1AND(
2CASE(network__c,
3"AD",1,
4"AX",1,
50
6) = 1,
7ISBLANK(TEXT(Payment_Type__c))
8)