How to use Decline in an Approval Workflow to change other cell values
I am quite frustrated trying to figure out how to use the Approval Workflow. I am working on a team task template which as an "assigned to" field and a "approval by" field. There is also a dropdown column for Status, with options "Not Started, In Progress, or Submitted". A separate column is used for Approval Status (Approved or Rejected). My goal is that when the person assigned the task thinks it is complete, they change the "Status" field to "Submitted". The "approval by" person then receives a notification. If happy, they Approve, and the row locks (that part is easy). If unhappy, they add a comment, and reject the task, and an update request goes back to the assignee.
My problem is that I want the "status" task to change back to "in progress" when "approval status" is set to Rejected by the workflow. That is so that the Workflow will trigger again when the assignee is ready to resubmit the task for approval. (Otherwise there is no way to re-trigger the approval workflow). I cannot find any way to accomplish this. Similarly, once approval status goes to Approved it would be great for Status to change to "Complete" instead of just "submitted".
I considered instead combining the Status and Approval Status in one but that leaves open the possibility that the assignee could simply change the status to 'approved' without the Approver actually reviewing it.
Am I missing something? Maybe there is a better way to accomplish my goal. I am very surprised that the Workflow features do not enable a cell to be set to a certain value by the workflows.
Help Article Resources
Check out the Formula Handbook template!