Count archived Trello cards?

Andrew Young March 9, 2022

My team would like to track development work progress. One metric of great interest, however imperfect, is to get a count of all archived cards. Is there a way to do this? I've Googled for it but found no working solution.

 

If it's not possible to easily count Archived cards, is there a way to bulk move all archived cards to a new Trello List that I name: "ARCHIVED"? Right now, the alternative is to go through each archived card, one-by-one, and send them back to the board then move them back to the "ARCHIVED" list.

 

Open to better ideas than the ones I've proposed.

4 answers

1 accepted

0 votes
Answer accepted
Andrew Young May 17, 2022

In my opinion, the best way to do this is to download/export the Trello board data as a CSV file then copy-paste that data into a GSheet that feeds a Google Studio report (or is consumed by some other analytics tool).

 

The CSV export has a column, "Archived," that takes on the values "TRUE" or "FALSE."

Hannah Humbert - Simpla Workflows
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 17, 2022

This is definitely an option if you don't mind using a different platform! My suggestion would be to _sync_ the data to GSheets rather than manually exporting it on a regular basis. With any manual work, it opens up room for error, it's time-consuming, and the information in your sheet is not dynamic. So let's say a card gets archived, but it turns out it's not fully complete and you un-archive it - you'll need to remember each time to also manually update your sheet. This might be ok if you're working with a small data set and it's just you using the board, but if things start to scale, you might want to use Unito to dynamically sync data from Trello to GSheets. 

Andrew Young May 26, 2022

Yes, agree 100% about manual work. Not sure my org would be interested in Unito / might think it's over-engineering but thank you for raising that interesting possibility!

0 votes
Robin Warren _Blue Cat Reports_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 10, 2022

If you are trying progress maybe you want to look at some reporting options

- Blue Cat Reports (general purpose reporting) https://trello.com/power-ups/5d9c90aa18965066fcd44730/reports-by-blue-cat

- Corrello (Agile teams reporting) https://trello.com/power-ups/568c2b6c7d2758a55ac48c98/agilescrum-kanban-dashboards-charts-corrello

Or have a look at our guide to the reporting options in Trello https://www.bluecatreports.com/trello-reporting/

Hope that helps :)

Robin

0 votes
Hannah Humbert - Simpla Workflows
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 9, 2022

@Andrew Young Dashcards would be able to count cards for you, but it doesn't look like you can filter on archived cards, only open cards. What could be a good option is to send cards to an "Archive" board instead and use dashcards on that board.

dashcards card counter.PNG

Butler could then move cards automatically to their correct list, e.g.

when a card is archived, move the card to the top of list "Done {monthname} {year}" on board "Archive", and unarchive the card

(the trigger could be when a card button is selected, when a done label is added, etc.)

Depending on how you report on things, the lists could be monthly like shown above, or weekly, quarterly, etc.

Butler won't apply retroactively, so it may take a bit of time to set up initially.

Andrew Young May 16, 2022

"What could be a good option is to send cards to an "Archive" board instead and use dashcards on that board."

 

Did you mean an Archive Trello list, or were you accurate in saying a Trello board? 

Hannah Humbert - Simpla Workflows
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 16, 2022

@Andrew Young yes, the suggestion was to have a secondary archived board to keep a record of completed cards without cluttering your main board. Alternatively, you could have the completed lists on your main board if you need to see the open and archived cards all on one board.

Andrew Young May 17, 2022

Gotcha. Interesting idea, thank you for sharing.

0 votes
milynnus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 9, 2022

@Andrew Young 

I do that to clean out my development boards. While it looks at the open cards now, it can be modified to look at closed cards. It moves all the cards to a new list (boardname)...move the move the list to a archive board, move empty list excluding some that I want to keep to a trash board....etc.

All this via a program but you can always trigger it from a card button.

At the end, there will be some programming need because all the Trello automation works on open cards.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events