I have a validation rule on Custom object which validates that if Status != Draft, it should not allow the user to change the employee.
It works fine all the values which has single word like Approved, Declined, etc.. But it is not working for the values have more than one word like Under approval, under verification.
Employee_c is Lookup field Status_c is picklist
Validation Rule 01:
NOT(ISPICKVAL(Status__c, "Draft")) && ISCHANGED(Employee__c)
I have tried in different way also.
Validation Rule 02:
NOT(CONTAINS(TEXT(Status__c), 'Draft')) && ISCHANGED(Employee__c)
But still no use. can you please let me what is wrong with validation rule? or is there any known issues.
WHen i am using only ISPICKVAL() it is validation rule works fine, but not with ISCHANGED.