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

[Mary Diers]

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!

[marin · Accepted solution]

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. 

[Mary Diers]

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

[Robin Warren _Blue Cat Reports_]

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

[Iain Dooley]

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