Automation to change status has expired
Hey guys,
I think there must be this solution here but I haven’t found it, I need it to change the Task Status when a specific date is due, I did some automation but it didn’t work here!
Hi @HenriqueDegan ,
To update the status when a date column is due, it could be as simple as:
However, that’s not going to assess if the item is for example in another status, so it’s going to override it. You can update the ‘when’ selection to trigger before or after that date and at a certain time.
You’d probably want to add on some conditions. For example, when the due hits, the next day at 6AM if the item is not in complete status, it will update the status to overdue:
Share your current automation so we can have a look what you were trying to execute and guide you on your own automation,