Automation triggerted when due date occurs

I have a problem when using Automation:

In Event Type, I chose: "Data Change" > "All Changes"

In Condition, I typed: "

OR(AND(
[Time until due] <= "-00:00:00",
[status]<>"Completed"
),
[status]="Overdue"
)

"

It only works if I change the [Due Date] manually that the column [status] is set to "Overdue". It can not automate run when the [Due Date] comes and meet the Condition above.

Can anyone help me? Thanks

0 3 138
3 REPLIES 3
Top Labels in this Space