Organizationwide report of all overdue tasks, all people, all projects

[jbirkes]

I have created a report of all people in my organization, of all tasks incomplete over the last 20 days. The result can be sort sorted by due date, but not by person. When I filter by person, the dates are not in order, just random. I need a report that generates 1st level by person, then the date overdue in order. I do not want to create tags, I just need to sort. There does not appear to be a way to download to excel and manually sort.

[lpb]

You can easily do this with Asana2Go by selecting your search results, then in Asana2Go choose the CSV Detailed format and output to a CSV file which you can open in Excel and do the multiple sorts as you mention; all the columns you need will be there.

For more info:

Asana2Go: Copy, export, and print from Asana flexibly (Free for most users/companies)

Asana2Go is a brand new multi-purpose tool that allows you to copy, export (CSV for Excel and Google Sheets, JSON), and print (or save to PDF) from Asana flexibly. To see what it can do, and how to use it, watch this video. Novices: Just select your tasks and a predefined report format and go. Experts: Create your own formats, essentially giving you access to the power of the Asana API without a complex programming language – use Markdown or HTML and a templating language with built-in editing…

Hope that helps,

Larry

[Marie]

Hi @jbirkes and thanks for reaching out! As it stands it is not possible to sort a report with two criteria (assignee and date in your case) but if you haven’t done so yet, I would recommend adding your vote to this thread How do I Sort by Assignee then Due Date. In the meantime, the solution offered by @lpb above should allow you to accomplish exactly what you’re looking for!