You need to sign in to do that
Don't have an account?
kfran
Need Help with ISPICKVAL Validation Formula
Hello,
I need help creating a Validation rule between two picklist fields. Something which says: If "X" is selected in custom picklist field 1, then Custom picklist field 2 cannot be blank.
Any help would be much appreciated.
Thanks!
AND(ISPICKVAL( Price_Stage__c , "Quote Needed") ,
BEGINS( Product_Group_short_oppty__c, "I"),
ISPICKVAL( Pricing_Strategy__c, "Don't Know"),"",))
Thanks for your response. I sometimes get an error stating that I have too many parenthesis, other times I get an error that I don't have enough. How is my AND function wrong? Did I correct it below?
if(
and(ISPICKVAL( Price_Stage__c , "Quote Needed") ,
BEGINS( Product_Group_short_oppty__c, "I")),
ISPICKVAL( Pricing_Strategy__c, "Don't know"), Null, ))
You never need to use IF(). The IF() is understood in the evaluation of the formula and evaluates only for the True result rather than a specific return.
Your validation rule should look like this (pardon my layout but, it does assist with support reading the rule if it is having troubles):
AND(
ISPICKVAL(Price_Stage__c,"Quote Needed") ,
BEGINS( Product_Group_short_oppty__c, "I"),
ISPICKVAL(Pricing_Strategy__c,"Don't know")
)
This is read as:
If
Price Stage is "Qoute Needed"
and
Product Group short oppty begins with "I"
and
Pricing Strategy is "Don't Know"
trigger the rule, else do nothing (notice that the do nothing is not used because this only evaluates for true)
Let me know if you need more clarification.
Message Edited by KC CRM Analyst on 09-16-2008 08:26 PM
b.2picklist is a depenent field,