Cancel Save and Before modified record saved
I am trying to cancel save when user role other than Administrator change the Approved Opty status to Rejected or Cancelled. Any one should be able to change the Status from Pending Approval to (Approved or rejected or cancelled).
I created workflow based on Opportunity object and triggering event is ‘Before modified record saved’ and condition is as below:
(([<ApprovalStatus>] ='Rejected' OR [<ApprovalStatus>] ='Cancelled') and PRE('<ApprovalStatus>') ='Approved' AND UserValue('<Role>') = 'Administrator') OR(([<ApprovalStatus>] ='Rejected' OR [<ApprovalStatus>] ='Cancelled' OR [<ApprovalStatus>] ='Approved') and PRE('<ApprovalStatus>') ='Pending Approval')
My issue here is, this workflow always triggering after the approval status set to Approved. If I change any field on Opty screen after Approval, Cancel save message pops up. I want this workflow to trigger only when Approval status is changed. Please help me to achieve this.