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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Order Cards by Month Completed Date rather than by Due Date

Hello Trello

Is it possible to order your cards by month completed rather than by Due Date?  

2 answers

Hi @Jennifer_Osborn ,

Welcome to the community as well as in the group!

Butler can help you out in sorting, filtering & automating things which will make your work easier!

 

Sorting lists on Butler for Trello:

You can sort lists by the due date, card name, votes, by the value of a custom field, or by a label with the sort list command, e.g.:

every day at 8am, sort list "Tasks" by due date

sort "Books" by name

sort "Tasks" by custom field "Start Date"

every wednesday at 12pm, sort "Proposals" by votes

sort the cards in list "Backlog" by age

sort the cards in list "To Do" by time in list

You can also reverse the order:

every day at 5:30pm, sort list "Done" by due date descending

every wednesday at 12pm, sort "Proposals" by votes ascending

sort the cards in list "Backlog" by age descending

sort the cards in list "Done" by time in list descending

Sorting by label requires specifying the order:

sort list "To Do" by label green, yellow, red

You can also specify label names:

sort list "To Do" by label green, yellow "High", yellow "Medium", yellow, red

Note that color without a name catches all the labels with that color regardless of title.

By default, name is sorted ascending (alphabetically), due date is sorted ascending (older due dates first), votes is sorted descending (more votes first), and time in list and card age are sorted ascending (less recent first). In by label, descending reverses the order of the sort.

Finally, the lists themselves (instead of their contents) can also be arranged by title:

arrange the lists on this board by title

UPDATE JULY 2017

You can now sort by two criteria, to break ties, e.g.:

sort list "To Do" by due date ascending and then by custom field "Points" descending

Simply add and the second criterion. Another example:

sort list "To Do" by label green, yellow, red and then by due date ascending


IMPORTANT

  1. This is a scheduled (e.g. every day at 8am, sort list “X” by due date) or immediate (e.g. sort list “X” by name) command. It's not a continuously running one: i.e. Butler Bot won’t keep the list sorted as cards are added to it.

  2. Alphabetical sorting is case-insensitive (i.e. "A" and "a" are considered the same).

  3. Alphabetical sorting is not locale-sensitive, i.e. it will sort according to U.S. English alphabetical order, not that of the user's language.

  4. The list is progressively sorted over a period of seconds or even minutes to avoid hogging all the Trello API quota by one user.

  5. If too many moves are required to sort a list (more than 100), the command will be stopped and the list will be partially sorted.

Hi Soumyadeep

Thank for the welcome and also for coming back to me so quickly.

I'm still not entirely clear (please forgive me if I have misunderstood) that this will achieve my desired outcome.  If I explain what it is I am hoping to do:

1. When a card is completed/archived, be able to sort by the month that it was completed in.

2. The purpose of this would be that I could then (and this is something else I need to investigate!) be able to review my cards completed for the previous month at a quick glance.  It would then be superb if I could compare when the due date set was to the time stamp when it was actually completed, rather than looking at each individual card.  I had a quick look through the API, but couldn't see a field that might denote that?  

Any help is always much appreciated!  

Hi @Jennifer_Osborn ,

Archived cards & lists can't be sorted!

You can make a new list and name it completed after completing any task just drag the card into that list rather than archiving the cards. And also by doing this, you will able to sort the list too.

Like Pritam Das likes this
0 votes
Iain Dooley Community Leader May 16, 2020

@Jennifer_Osborn rather than archiving the cards, you can move them to a Done list, and then every month rename the Done list to "Done {monthname}" using Butler and create a new Done list. In order to avoid your board slowing down over time, you can move those "Done {monthname}" lists to a special archive board (you might also like to use a new archive board each year/quarter depending on card volume.

In order to resolve your issue of seeing when a card was due vs when it was completed, you could use a custom field "Date Completed" which you could set to the current date when the card is moved to the Done list.

Thanks @Iain Dooley not a bad couple of workaround ideas from the face of it I think.......I think I'm going to have to develop my Butler skills a little further however as I am still very new to using it and it has been a long day! :)  

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

📹 What is Trello?

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...

776 views 13 30
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you