Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SandrineSandrine 

validation rule : Avoid modification of picklist when a check box is true

Hello,

I want to implement a validation rule in case to not et users modify a field.

I have a field picklist with values 
custom_picklist__c
Value: ABC, CDB.

I have a Check_box1_c

If the Check_box1_c is true and the custom_picklist__c =ABC, dont let user to modify.

How can i implement this vlaidation rule 

thanks you for suggestion 
Best Answer chosen by Sandrine
Sunil RathoreSunil Rathore
Hi Sandrine,

Greetings to you!
Please refer the below formula: 
IF(
  AND(
      ISPICKVAL(picklist_field, text_literal),
      Check_box1_c = true,
      ISCHANGED(picklist_field)
      ),true,false
)

Hope this will help you. If does then mark it as the best answer so it can also help others in the future.

Many Thanks,
Sunil Rathore

All Answers

Sunil RathoreSunil Rathore
Hi Sandrine,

Greetings to you!
Please refer the below formula: 
IF(
  AND(
      ISPICKVAL(picklist_field, text_literal),
      Check_box1_c = true,
      ISCHANGED(picklist_field)
      ),true,false
)

Hope this will help you. If does then mark it as the best answer so it can also help others in the future.

Many Thanks,
Sunil Rathore
This was selected as the best answer
Shivam Yadav 8Shivam Yadav 8
Hi Sandrine,
Please refer the below formula:

AND( TestForCheck__c = True,
ISCHANGED( picklist_field) )

Thanks