We are looking for a feature that can give us the ability to track how long a certain task has been in a section. We are not looking for a time tracking software like harvest. Ideally, when looking at the board view, we could have a dynamic drop-down that counts the number of days that a task has been in a section and can even have a warning symbol if it goes past a certain number of days in that section. The due date works, but it does not indicate how long something has been there.
Hi @Jake_Ritter, the only tool I’ve come across that tracks and reports on this time-spent-in-column/section data is Screenful.
Our team is utilizing asana as an “open seat” tracker for our HR needs. We have all our jobs in one of three sections
- On Hold
- Open Seat
- Filled Seat.
It would be incredibly helpful to be able to be able to review metrics of time a task has spent in each section. (e.g. Job x has spend 7 days in the open seat section)
I see metrics in asana about time to complete. But completing a task isn’t really what we are looking to do. We are hoping to lean into just dragging tasks between sections. Does anyone have a tip on this? I know there were supposed to be additional reporting metrics, but I could not figure out how to do what I am looking for!
Any help is appreciated!
I do not believe Asana has the exact capability you are looking for. However, Asana usually has a workaround!
Here are my thoughts:
Create a custom field called “Open Seat Tracker”. Your fields will be “On Hold, Open Seat, and Filled Seat.”
Create a custom field called “Time Tracker”. Your fields can be numbered 1-14, or however long you desire
Create three separate rules as follows:
Rule #1
-
Trigger: When “Open Seat Tracker” is changed to “On Hold”
-
Action: Move to section “On Hold”
Rule #2
-
Trigger: When “Open Seat Tracker” is changed to “Open Seat”
-
Action: Move to section “Open Seat”
Rule #3
-
Trigger: When “Open Seat Tracker” is changed to “Filled Seat”
-
Action: Move to section “Filled Seat”
Unfortunately, there is no way to automatically add the number of days in so that would be manual, but you can also create rules around those when you change it and want your project to move tasks around.
To add to Mike‘s answer here is a relevant feedback request thread where you can leave your vote as well: Track the number of days a task has been in a section
And it seems you can create such reports eith screenful: Track the number of days a task has been in a section - #3 by Phil_Seeman
Would be great to be able to see and report on Age of task or time in Section(s) or time in WIP for Scrum/Kanban. Then having workflows around if something gets to a certain time then it does something. I’m trying to identify stalled tasks and unresponsive requests in my org. Due dates don’t really work for this very well.
To create the custom field, you could add a “Date” field type and name it something like “Section Start Date”. Then, when you move a task into the section, you would manually update the value of this field to reflect the current date.
To calculate the number of days the task has been in the section, you could use an automation rule that triggers when the value of the “Section Start Date” field changes. The rule would calculate the number of days between the current date and the value of the “Section Start Date” field, and update a separate “Days in Section” field with this value.