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