Approval workflow validation
Is there an easy way to validate that a request for approval submitted via a form is not approved by the person who created the request?
My sheet contains a Contact List column from which approvers are selected. I have tried to validate this entry against the 'Created By' column but this does not match as the contact list entry only matches the name and not the email address. Created By = 'Andy Harris', Approver = '[email protected]'.
I want my workflow to be able to reject approval requests that have been submitted by the same person as the selected approver.