You need to sign in to do that
Don't have an account?
VRK
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
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
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.
Best Regards,
Anthony McDougald
All Answers
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.
Best Regards,
Anthony McDougald
its working perfectly and thanks for saving my day ....
Appreciate on this ..
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
Do you mean the record type?