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
Hi, This is great and I have set up something similar. If however if our plan is updated ie the due date was in the past (so set to ‘late’ status) but is then updated to be in the future (so now ok/not late) how can you get the status to change back to ‘ok’?
1 Like