I have an automation rule in place that is triggered and send me an email notifications when the task status is “Delayed”. In addition to this, I need to rule to to be triggered only after certain tasks are completed,
For example, In the Doc there is a list of tasks to be done and I need this automation to send me notifications on task delay only after the “MC release” task is marked completed.
Since Status is a calculated formula, even if it changes from ‘On track’ to ‘Delayed’ that won’t trigger a ‘Row changed’ automation, so what I would do is (assuming you’re on a team plan) :
Create an additional column Notified to mark tasks as notified
Set up an automation to run every hour
Check if there are ‘Delayed’ tasks where all the tasks it ‘Depends on’ are complete and that have not been yet ‘Notified’
For each of those
send a notification
set them as ‘Notified’
I took the liberty of implementing that directly on your doc.
/* Get tasks that are delayed, not notified and where the number of 'Depends on'
tasks that are not complete is 0 (in other words, all are complete) */
Timeline.Filter(
Status="Delayed"
AND Notified.Not()
AND [Depends on].Filter([Progress Status]!=Complete).Count()=0
).let(delayedTasks,///Store the list of delayed tasks in a variable
If(
delayedTasks.IsBlank(),
///If there are no delayed tasks, don't do anything
NoAction(),
///If there are, for each of them send a notification and set it as notified
delayedTasks.ForEach(
RunActions(
Notify([VINAY B C],Format("Task '{1}' is delayed.",CurrentValue.Feature)),
CurrentValue.ModifyRows(Notified,true)
)
)
)
)