Automatically Change Value in Drop-Down Box
I might be overthinking this, but I have a drop-down box (called PD/C Approval Status that is used for automated request for approval) that includes the following values:
- Not Approved
- No Response
The default is "---" until the approval workflow is initiated, which then changes is to "Requested" (via the workflow). Obviously, the person then clicks Approved or Not Approved, which also automatically changes the value in the column.
However, I want to change the value to "No Response" automatically if the person does not respond to the approval request. I have another column (called Approval Elapsed Time) that calculates the elapsed time from when the request was sent to TODAY(). If the value is greater than 0 (meaning today was the day the approval was needed), I'd like it to change the drop-down value to "No Response".
I thought I might be able to do this via the Change Cell Value workflow, but apparently you can use this with drop-down boxes.
Any workaround suggestions?
Help Article Resources
Check out the Formula Handbook template!