You need to sign in to do that
Don't have an account?
DanielBProbert
Comparing to Multipick lists validation rules
Hey,
I have 2 identical multi-pick lists that I would like to put a validation rule on.
MP 1 = Exams_Sat__c
Options = Exam 1, Exam 2, Exam 3, Exam 4
MP2 = Exams_Passed__c
Options = Exam 1, Exam 2, Exam 3, Exam 4
What i would like the rule to do is
IF Exam 1/2 & 4 were selected as exams Sat, when you come to set the passed exams if you select Exam 3 you get an error telling you that you have selected an exam that wasn't sat.
Any ideas or is this not possible?
Cheers
Dan
You can use the INCLUDES in the formula for the VR.
(
INCLUDES(MP1,"Exam1") &&
INCLUDES(MP1,"Exam2") &&
INCLUDES(MP1,"Exam4") &&
INCLUDES(MP2,"Exam3")
)
This is the main idea - syntax may/not be perfect.
AND(
INCLUDES(MP1,"Exam1"),
INCLUDES(MP1,"Exam2"),
INCLUDES(MP1,"Exam4"),
INCLUDES(MP2,"Exam3"))
The only thing is with multi-select picklist fields is that you have to add syntex for every option so more than one validation rule may have to be made depending on the amount of options there is. The more suitable way to complete this, may be by creating an Apex Trigger.