Advanced Automation

Hi

I have an automation set up that when a end date is in the past then the owner of that tasks gets an alert every day until it is updated. I would like to further add to that automation that if that task isn't updated within 2 days then an alert goes to a named person, is this possible?

Thanks, in advance

Amanda

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Amanda O

    There are different approaches but I would do it with a separate automation specific to this task. 2 days past a reminder that is already 1d overdue is end date +3. You may need a helper column that is counting days past end date when task isn't completed (approved, etc) to have complete flexibility of what day you want the automation triggered at. The Duration helper column would look something like =IF(whatever would indicate it hasn't been completed, TODAY()-[Due Date]@row) You would need to change [Due Date] to name of your date column.

    Would this work for you?.

    Kelly