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
User | Count |
---|---|
17 | |
11 | |
7 | |
4 | |
3 |