Adding an additional rule/condition for an exisitng automation

1

Hello,

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,

CODA Doc link : https://coda.io/d/_dvta6Z-VYJh/Timeline_suFnjzct

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.

Thanks in advance.

1 Like
2

Hi Vinay,

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)
      )
    )
  )
)

Hope this helps,

Pablo

2 Likes