Is there any way to auto update task State to “overdue” once the Date field value past today? I don’t see any trigger to monitor the date value in the field (not actual time schedule, which is possible).
I think for such things you just have to run a check on a schedule. Is that not an option in your case?
1 Like
I didn’t think about that! Thanks for the quick response!
1 Like
Or you can create a formula field that calculates if the date has been reached e.g. Date ≥ Today()
and then use an automation that triggers when this field becomes true.
2 Likes