My validation rule
AND( $Profile.Name <> "System Administrator", $User.Id <> "0053600000xxxxxxxx", NOT(ISNEW()), NOT(CONTAINS("Kristen Becker:Lisa Wilt", Permission_To_CSM__c )) )
The validation rule need to satisfy the below conditions
- Only works on edit mode.
- The System Administrator can do anything with the record.
- User with Id==>0053600000xxxxxxxx can do anything with the record as like admin.
- When Lookup relational field Permission_To_CSM__c has value only "Kristen Becker" or "Lisa Wilt" then the user can edit the record.
Why my validation rule can not satisfy the above requirements. Help me to fix the validation rule.
User Fields in validation rule.
Validation rule error