You need to sign in to do that
Don't have an account?
Jenny Fisher
Multi Pick list Validation Rule
I have a multi pick list field called, Plays_c. When the option "Retained Customer's Business" is chosen from this field the
single Pick list Type of Business_C field is required. None of the other multi pick list values are required to pick type of business but the rule I created below is making it so. How do I correct this. I just want "Retained Customer's Business" to drive the type of business pick list. Here is my current validation rule I have.
And(
INCLUDES(Plays__c, "Retained Customer's Business"),
ISBLANK(text(Type_of_Business__c)))
Any help would be awesome.
single Pick list Type of Business_C field is required. None of the other multi pick list values are required to pick type of business but the rule I created below is making it so. How do I correct this. I just want "Retained Customer's Business" to drive the type of business pick list. Here is my current validation rule I have.
And(
INCLUDES(Plays__c, "Retained Customer's Business"),
ISBLANK(text(Type_of_Business__c)))
Any help would be awesome.
I tried your validation rule in my org, its working perfect.
Make sure your validation rule is "ACTIVE".
Best Regards,
Mithun.
Yes was another validation rule that was throwing it off. I go that corrected. Now when I choose pick list value Retained Customer's Business the Type of Bussiness field is not required.
Here is the validation rule. Can you help me?
And(
INCLUDES(Plays__c, "Retained Customer's Business"),
ISBLANK(text(Type_of_Business__c)),
$RecordType.Name = "Complex Event",
$Profile.Name <> "OCM System Administrator",
$Profile.Name <> "System Administrator")
1) The above Validation Rule is active.
2) The Plays__c field does have the "Retained Customer's Business" value(spelling is also correct)
3) RecordType is "Complex Event" (spelling is also correct)
4) The current User is not "OCM System Administrator" or "System Administrator"
If all the above criteria is met, then the error should throw.