I have created a validation rule whenever the picklist Field (status) is N/A I have to make another fields as not editable based on the picklist values .
Below is my validation rule :
AND(
ISPICKVAL( status__c,'N/A'),
ISCHANGED( NHPMS__Re_Admit__c ),
ISCHANGED( NHPMS__Discharge_Date__c ),
ISCHANGED( Next_Appointment__c )
)
I am able to change my Next appointment (pickList Field) and discharge date (Date Field)
Best Answer
Your current validation rule says the following
Block the user if the all of the following is true:
Status__c
= 'N/A'NHPMS__Re_Admit__c
IS CHANGEDNHPMS__Discharge_Date__c
IS CHANGEDNext_Appointment__c
IS CHANGEDIn your screenshot, only #1, #3, and #4 are true. You are not changing
NHPMS__Re_Admit__c
so the validation rule does not block you.Based on your requirement, it sounds like you either:
NHPMS__Re_Admit__c
changes, in which case just remove itor
For that second scenario, you should leverage OR to denote that any of those fields changing meets criteria
The above will now block the user if the following is true:
Status__c
= 'N/A'