+ Start a Discussion
VRKVRK 

Required Validation rule to control multipicklist value based on picklist value

Hi 
pls find scenario below:
I have Task category picklist and values  ' Add' , 'Edit' ,'Override' and 'PF'.
And
Region is multi picklist  and values are 'US','UK','China' and 'Global'.

my rquirement is :
Global Region picklist value is only applicable for PF Task category.
Other Task category values try to select 'Globa' fire an error message.

I write below VR rule ...but its not working .. can some one pls check and help on this:
AND( 
OR(
ISPICKVAL(Task_Category__c,“Add ”),
ISPICKVAL(Task_Category__c,“Edit”), 
ISPICKVAL(Task_Category__c,“Override”) 

)
NOT includes(Regions__c ,"Global")
)
But its not working , can you pls help on this
Best Answer chosen by VRK
Anthony McDougaldAnthony McDougald
Hello Sekhar,
Hope that your day is off to an amazing start. The rule you're looking for is below. Hope this helps and may God bless you abundantly.
AND(
NOT(ISPICKVAL(Task_Category__c, "PF")),
INCLUDES(Regions__c, "Global")
)


Best Regards,
Anthony McDougald

All Answers

Anthony McDougaldAnthony McDougald
Hello Sekhar,
Hope that your day is off to an amazing start. The rule you're looking for is below. Hope this helps and may God bless you abundantly.
AND(
NOT(ISPICKVAL(Task_Category__c, "PF")),
INCLUDES(Regions__c, "Global")
)


Best Regards,
Anthony McDougald
This was selected as the best answer
VRKVRK
Sorry Anthony  ,pls ignore my earliy message.
its working perfectly and thanks for saving my day ....
Appreciate on this ..
VRKVRK
Hi Anthony,
i have one more question:

OR(
ISPICKVAL(Priority , "High"), Justification__c ="",
ISPICKVAL(Priority , "Medium"), Justification__c =""
)
In above, VR Rule, i can restrict 'Medium' Priority picklist value for Record 'ABC' only....................how can i add condtion ?
Thank you
Anthony McDougaldAnthony McDougald
Good Evening sekhar,
Do you mean the record type?