At the end of next year, I want to look back and see how many of my tasks went into a particular status. For example, if I want to see how many tasks went into blocked, I want to export a document next year that looks like:
Task Name | In Progress | Completed | Blocked
My Task | x | x
My 2nd Task | x | x
I could then export this to excel and count the rows with an entry in the Blocked column.
Any suggestions?
Hi @Robert_Starr, welcome to the Asana Community Forum!
I recommend you creating a project, adding a Status custom field and include these options in the drop-down: In Progress, Completed and Blocked. You will be able to export this project at the end of the year and see all tasks that were marked as Blocked.
Alternatively, you will also be able to create an Advanced Search report in Asana by tasks marked as Blocked on that specific project and then export only this list instead of the entire project.
I hope this helps! Let me know if you have any questions when creating the project 