I've been trying to set up a system that when a card is due soon, it gets assigned a red label; if it's due fairly soon then it gets an orange label. Cards get assigned a colour label when they started (usually green), but there's an automation that, at a certain point, replaces them. I've tried it two different ways with due date automations & labels but it's not working properly. The latest version was to set up these 5 standard "Due Date Automations": * on the sunday before a card is due, add the red "This week" label to the card * on the sunday before a card is due, remove the lime "Longer term" label from the card * on the sunday before a card is due, remove the orange "Next week" label from the card * on the sunday of the week before a card is due, remove the lime "Longer term" label * on the sunday of the week before a card is due, add the orange "Next week" label to the card What seems to be happening is that the last 3 rules aren't working. So red labels are getting added OK (and perhaps lime ones are getting removed - they're a rare case), but orange is not getting added or deleted and lime isn't being deleted as per automation 4. My previous effort just had them as two automations, one for the Sunday before, on for the Sunday of the week before. I found a similar previous post, but the questioner disappeared after @Lara suggested checking the command log so there's no solution. I've checked the command log and there are no issues (it says it ran successfully). I have checked "Enable automation on board" is enabled in every case. Any help would be much appreciated. I'm open to entirely different ways of solving the problem. Thanks

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Due date automations not working with labels

Matt Page_rucu4m

I've been trying to set up a system that when a card is due soon, it gets assigned a red label; if it's due fairly soon then it gets an orange label. Cards get assigned a colour label when they started (usually green), but there's an automation that, at a certain point, replaces them.

I've tried it two different ways with due date automations & labels but it's not working properly. The latest version was to set up these 5 standard "Due Date Automations":

on the sunday before a card is due, add the red "This week" label to the card
on the sunday before a card is due, remove the lime "Longer term" label from the card
on the sunday before a card is due, remove the orange "Next week" label from the card
on the sunday of the week before a card is due, remove the lime "Longer term" label
on the sunday of the week before a card is due, add the orange "Next week" label to the card

What seems to be happening is that the last 3 rules aren't working. So red labels are getting added OK (and perhaps lime ones are getting removed - they're a rare case), but orange is not getting added or deleted and lime isn't being deleted as per automation 4.

My previous effort just had them as two automations, one for the Sunday before, on for the Sunday of the week before.

I found a similar previous post, but the questioner disappeared after @Lara suggested checking the command log so there's no solution. I've checked the command log and there are no issues (it says it ran successfully).

I have checked "Enable automation on board" is enabled in every case.

Any help would be much appreciated. I'm open to entirely different ways of solving the problem.

Thanks

Accepted answers

Matt Page_rucu4m

Having had a support ticket worked through with this, the problem with this seems to stem from "the Sunday of the week before". Apparently the system's week in this context is defined from running Monday to Sunday. So "the Sunday before" = "the Sunday of the week before" – the two options work in entirely different ways. The first (just "before") is the literal 7 days before the due date. The second looks at calendar weeks running Mon→Sun, finds the one the due date is in, goes to the calendar week before and picks the relevant day.

So the solution is to run this on the Monday instead (it runs in the early hours, or you can specify a time). The "the Monday before" will always be fewer than 7 days before, "the Monday of the week before" will always be the first day of the calendar week before, so 7 days or more.

Still not 100% sure what happens when the due date is a Monday, but otherwise this seems to be working.

All comments

Vishaal S

Hey Matt,

Vishaal here with Trello Support—thanks for reaching out

Just to reiterate- Could you please confirm that your card due dates are incomplete? These due date commands won't work if the due date is marked as complete, try setting up a simplified version of these rules on a test board to see if they execute as expected in a more controlled environment. This can help determine if there’s an issue with the rule configuration or if it’s related to the specific board and the rule overlaps with the board you are working on.

Alternatively, The Card Aging Power-Up in Trello could indeed be a simple and effective alternative to changing labels based on due dates. This Power-Up will visually indicate on the board when cards haven't been updated in a while, which could act as a signal for approaching deadlines or the need for attention. Would something like this work for you: https://trello.com/power-ups/55a5d917446f517774210012

Matt Page_rucu4m

Hi Vishaal,
Thanks for these suggestions. The due dates are incomplete.
I'm really pushed for time today, but I will try testing in a more controlled environment next week.
Good idea about the card aging. If we can't fix it this might be a viable alternative.

Thanks again.
Matt

Vishaal S

Sure, Matt. Do reach back incase if you've more questions, Happy to work together on this

Matt Page_rucu4m

Hi @Vishaal S
Since last week I've run two different tests.

Test 1 was on the existing board separating out the rules so that adding labels happened on Saturday and removing them happened on Sunday. This gave the same results as before (the last 3 results didn't work

Test 2 was, as you advised, to set up a test board with simplified rules. This added the new labels, but did not remove the old ones. (which is a slightly different error than before)

Any ideas about how we can troubleshoot these?
Thanks

Matt

Matt Page_rucu4m

Still not 100% sure what happens when the due date is a Monday, but otherwise this seems to be working.

Matt Page_rucu4m

@AMIT SAXENA

This post from the 10th Nov (the "Accepted Answer") that should hopefully explain things for you.

AMIT SAXENA_1176o2

@Matt Page : Thanks for helping. In my case the Due Date automation instructs to change label when Due date is between 8 days & 14 days in which case add "14 days" pink label, etc. But it fails to trigger. Due Date automations set on the board.jpg