Is there a way to get the detail on tasks exported from a Portfolio into Google Sheets? I like the Workload tab very much, but it has some limitations, for instance:
- I cannot create a summary row to see total effort for the whole company
- When hovering over an individual’s workload, sometimes they are assigned tasks in so many projects that the screen does not have room to show me the comparison of assigned effort vs available effort at the bottom
I think I could create some solutions if I had the Workload data in Google Sheets, but it appears that exporting the Portfolio only gives me aggregate task data, not tasks at the individual assignee level like Workload.
Currently I’m using a kludgy Excel of my own creation, and supplying the data through multiple advanced searches using CSV exports (since CSV exports truncate at 2000 rows). Portfolio/Workload is such a neat tool, I was hoping that I was missing some way to easily toss that data into a more flexible format. It seems strange that the data is only available to be sliced one way (by project) instead of also by assignee, when the Workload tab shows that Asana is using the data sliced by assignee.