Automate a status change based on the date

can we with the automation update a status according to the due date. Let me explain. I have a due date of April 15, I would like more than 7 days before my deadlines column to be green with mention “TO DO”, between 7 days and D0 in orange with mention “ATTENTION” and if the date is passed in red with mention “LATE”


Yes, you can use this template:

Or, go directly to the custom automations and set up something like this:

Note that in both situations the “When” parameter can be set to consider days before or after the given date:

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Keep your Integromat scenarios from timing out! - YouTube
Contact me directly here: Contact – The Monday Man