You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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":
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.
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.
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
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?
Hey @Matt Page
Would it be convenient for you to create a support ticket through our support portal: https://trello.com/contact? 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.