Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,299,829
Community Members
 
Community Events
165
Community Groups

Report on completed Trello cards

For 19 years I have used a CRM developed internally by my company that is specific for a product line that we use. It is incredibly fast and amazing and I love it passionately (that's saying a lot, I know). I have more than 1,000 contacts in this CRM including more than 400 that are currently active contacts.

The Task manager allows me to add future tasks, with a key filter being able to define the type of task (appointment, call, email, letter, thank you [to write], etc. +10). The Task view shows me all pending tasks, which usually hovers in the 5-10 outstanding. The History view gives me the exact same view as the Task view, only it displays the completed tasks. I can filter this in three primary ways:

  • Date (several pre-sets or any custom-date range)
  • Task Type (appointment, call, thank, etc.)
  • Text filter (after the above two, I can further filter by any task found either in the task description OR the contents of the notes within any completed task).

Here is a screenshot of this history view, along with the lightning-fast text filter:

TNTHistory.png

Over my 19 years of using this software, I have amassed more than 58,000 completed tasks, in addition to thousands more automated [passive] CRM actions (the history log automatically tracks any change made to a contact's contact information).

This is an incredible treasure trove of information. For example, I can export this completed task list to Excel and create quick charts of how many tasks I completed in a year, by task type, who completed it, etc.

This CRM is profoundly helpful for my customer work and I use it daily.

But for my personal productivity and now leadership of more than a dozen team members, I use Trello for all of the reasons everyone who uses Trello knows.

My problem in using it, though, is that when I Archive a Trello card, I feel like I am just dropping the completed index card into a bin of completed cards. Over the years I have archived hundreds of Trello cards. A decade from now that could be thousands. If I completed the same 58,000 tasks in Trello that I had in our software, instead of instant reporting, all I have is a pile of cards with only one way to find a historic card: Search. And the results are the cards themselves.

How can I create a history report (e.g., list form) of completed cards? This is the primary indicator of when a card has moved from my "Active" to "Completed" file. The ability to scroll through—or further filter—a completed list is a key tool in my long-term success.

2 answers

1 accepted

1 vote
Answer accepted

Hey @Bob Mac Leod 

 

There are some ways you can work in Trello which would let you see your past completed cards

The main one would be to create a  new 'done' list periodically (every month?) and then move the old one to an archive board (just a standard Trello board you send all your completed cards to). In that way you have an archive of what was done and when (assuming you give your done lists useful titles like 'Done Nov 2021' etc.)

Or you could look at 3rd party power-ups like Blue Cat Reports which let you create reports on things like Completed cards (and a whole bunch of other stuff)

 

Hope that helps

Robin

Thank you for the helpful suggestions. Those are good ideas—I need to use Trello better (e.g., "Done" lists) to then produce better reporting. I tried Blue Cat Reports and see that it is only as good as the effort I did in advance. For example, I can produce a list of Archived cards... but it doesn't show the Archive date. So if I manage my completed cards better, then that report will work effectively.

 

Bob When you say task manager, is it a Power Up Or a extension of your contacts

 

Thanks

 

peter

In my corporate CRM, the contacts and the tasks are linked. When I am in the Contacts View and see all of my contacts, on any individual's contact card I can click on the tab for Tasks and see the future tasks for that one person, and History tab to see the completed tasks.

Or, I can select the Tasks View or History View and see all future tasks (few) and completed tasks (60,000+). It is in this History View that I can filter and search and export any/all completed tasks. This is very helpful for reporting. For example, there is a query someone wrote that will produce a chart of the number of every type of task (phone call, face-to-face appointment, thank you mailed, etc.). A report like this helps me see how I am doing this year compared to previous years—helps me analyze if I am putting my energy in the right place.

Because the History is linked to the specific contact for whom I did the action, I can drill down to that specific person and see all of my history. (I can also see groups; if it is a mass-mailing, for example, I can link one history action to all recipients of the mailing.)

For Trello, I am not seeking to link my completed tasks to any individual contact/person. I desire the reporting that [for example] tells me how many cards I closed/archived during a time period. 

Suggest an answer

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

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend  B...

2,396 views 28 41
Join discussion

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