I have a requirement where if the record has been sent for approval/approved/rejected (via the Approval status field), the record should not be allowed to be edited, with exception of Comments field, which can be edited even if the record has any of the above mentioned approval statuses. How to achieve this via validation rules?
My current validation rule is posted below, not sure how to add the exception of Comments field to this rule. I only want the comments field to be edited, nothing else.
AND(
NOT($Permission.Bypass_Validations),
$Profile.Name <> "System Administrator",
OR(
ISPICKVAL(ApprovalStatus__c,'Approved'),
ISPICKVAL(ApprovalStatus__c,'Rejected'),
ISPICKVAL(ApprovalStatus__c,'Pending')
)
)