Notify someone if no rows are added or changed everyday at specific times

Options

Hello,

I am trying to set up a sheet where there are two people being notified to complete and submit a checklist twice a day (already set up to notify them each at 9:00AM and 1:00PM). I want to create an automation that sends a notification to my boss if there is no submission by any party at the end of the day (5:00PM). How would I go about setting this up?

Answers

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Options

    The only way I can think of is to create an automation that runs in the middle of the night to uncheck a box and set up an additional automation to run when rows are added or change that will check that same box. Then have your 5 pm automation set to run daily if that box is unchecked.

  • clairehunter
    Options

    @Holly Green The only reason this wouldn't work is because the sheet itself is completely blank until the first person submits the checklist and it should create a new entry each time.