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,295,560
Community Members
 
Community Events
165
Community Groups

Can you track how long a card sits in a column in Trello?

We're looking to track how long each card sits in Trello and pull a report on the average time cards sit throughout a project. Will this require a Power Up?  Thank you!

3 answers

1 accepted

0 votes
Answer accepted

Hey Mary, I don't think you can do that without a power-up, but if you are willing to use a power-up you can do that with https://assista.io - it is a timetracking bot we are developing that tracks exactly this and gives you detailed statistics about who moved the card and how long it stayed in the "tracking lists" of your choice. 

Awesome, thank you, Marin! I will look into this.  

Like marin likes this

Hi Mary,

A couple of other options for you

Time in List tracks (as you might expect) the time cards spend in each list https://trello.com/power-ups/5b4765f383dd7c75d8e57be4/time-in-list

Or Blue Cat Reports allows more complex reporting such as the Time to Complete charts wich can track the time taken to complete cards over one or more lists. Those can show total time for all cards or be broken down by member/label/watever! Details on using the Time to Complete charts here https://www.bluecatreports.com/help/articles/create-a-time-to-complete-chart/

Cheers,

Robin

0 votes
Iain Dooley Community Leader Jul 20, 2021

@Mary Diers The following Butler variables track this information built-in:

{cardhoursinlist}
{cardminutesinlist}
{carddaysinpreviouslist} 
{cardhoursinpreviouslist}

You can read more details about these variables (and others) here:

https://help.trello.com/article/1157-variables

You can use these variables in Butler reports:

https://help.trello.com/article/1192-creating-reports-with-butler

You could also do something like track time spent in the previous list in comments/custom fields/descriptions with each time you move a card, then export this data either through the API or using something like the Board Export powerup:

https://trello.com/power-ups/5c9418019e56bd8abf98d83f/board-export-excel-csv-pdf

Hi!

I'm trying to use this variables and create a report, but it  doesn't work for me (

Command:

create a report with all cards in list "Ручная сборка и ВТО" using pattern "[{cardname}]({cardlink}) ({cardmemberusernames}) ({cardhoursinpreviouslist}) / ({cardminutesinlist}) / {cardhoursinlist} |", and send an email notification to "bernadskaya@gmail.com" with subject "отчет" and message "{$report}"

 

Result without any time:

MYK-H-002-P620 (user72122515, elenasinovac) () / () / | тест (n_bernadskaya) () / () / |KRD-SS-004-204 (elenasinovac, m_hanina) () / () / | BRK-W-002-P615 (user72122515, elenasinovac) () / () / | 

What I do wrong?

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,315 views 28 40
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