Order Cards by Month Completed Date rather than by Due Date

[Jennifer_Osborn]

Hello Trello

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

[Soumyadeep Mandal]

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.

[Jennifer_Osborn]

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!  

[Soumyadeep Mandal]

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.

[Iain Dooley]

@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.

[Jennifer_Osborn]

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! :)