Secondary Notification Automation -
I have a request form built that will be released throughout our region. Based on which office location is selected, a designated person will receive a notification that a new line has been added to the sheet through the form. Example: Someone in Austin, TX completes the from - John gets notified.
My quandry: If John does not go in and review the line on the spreadsheet and mark it complete within a day, is there a way to send a secondary notification to someone else the next day? Or can you only do notifications at the time of action?
This would be a fail safe so if John was out on PTO for a week, someone would receive a notification that his tasks weren't completed.
Thanks for any help.