Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

Suggest an answer

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

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

359 views 7 17
Read article

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