+ Start a Discussion

Validation rule code to control modification of picklist


I have below settings:



I want to implement Validation rule like below:

Validation Rule 1:

If picklist_custom__c  = C,
   then only User is able to choose picklist_custom1__c = X 

Validation Rule 2:
If  picklist_custom1__c = X,
 Then dont allow user to modify it

What should be validation rule code.

Thank you for sugestion.
Best Answer chosen by Sandrine
harsha vardhan vasa 9harsha vardhan vasa 9
For validation rule 1 u can go for dependent picklist. controlling field will control the dependent field.
 else u can write one validation rule in such a way that user has to give picklist_custom1__c  =x when picklist_custom__c  ==c:
 IF(TEXT(picklist_custom__c  ) == 'C',TEXT(picklist_custom1__c )='X',false)
 if any other value in the picklist_custom1__c  record wont be saved. 

Hope this is helpful.