Automating alerts based off date modified
I have read a number of posts about creating alerts/reminders based on a modified date column, but I haven't found the answer I am looking for. Maybe you have it? *crosses fingers*
I met with Pro Desk on Monday and it was suggested that I use the "Within the last days" option, however this doesn't work because it will trigger anything within the last number of days, whereas the escalation needs to occur only after 7 days.
How the sheet works:
There is an approval workflow that is set up to send reminders twice a week when a request is left "pending". We need to be able to escalate the pending requests to the staff members line manager to follow up (ie the staff member is on leave therefore not receiving the reminders but because the alerts are sent from Smartsheet, no autoreply explaining that detail is known to the Project Office).
The issue: Because there is no way to calculate the number of reminders sent and then automate an alert to the line manager, I thought that I may be able to use the date modified column to trigger a notification once the sheet has not been updated in the last 7 days. The "greater than" option only allows a date field, not a number of days field.
To complicate things: There are 6 steps in the approval workflow (therefore 6 approval columns), so I need to be able to add a condition so that it's only reporting the staff member who has not responded to the approval request.
Please help! Thank you!
Help Article Resources
Check out the Formula Handbook template!