Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Due date automations not working with labels


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":

  1. on the sunday before a card is due, add the red "This week" label to the card
  2. on the sunday before a card is due, remove the lime "Longer term" label from the card
  3. on the sunday before a card is due, remove the orange "Next week" label from the card
  4. on the sunday of the week before a card is due, remove the lime "Longer term" label
  5. 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.


2 answers

1 accepted

0 votes
Answer accepted

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.

0 votes
Vishaal S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Oct 05, 2023

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:  

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.

Vishaal S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Oct 06, 2023

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

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?


Vishaal S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Oct 12, 2023

Hey @Matt Page 

Would it be convenient for you to create a support ticket through our support portal: By doing so, we can delve into your specific scenario to ascertain if there are any issues or conflicting Automation rules. To assist you better, we may request impersonate access and the specific URL of your board for a more thorough examination.

Thanks @Vishaal S . I've done that now. I'll post back if they find an answer.


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events