No problem. I’m glad that approach is useful to you. The Google sheet thing is something you have to request from Asana. If you get in touch with your customer success person, they’ll be able to sort it out. This adds a ‘Sync to Google Sheets’ option to export:
Once you’ve set that up, you can create a new spreadsheet in Google Docs, then paste in the share link, and the data will be imported and synced - the sync is almost instant in some of the tests I’ve done. It syncs all of the same information that you’d get from exporting as a CSV.
A warning, however: Google Sync is an experimental and unsupported feature, so if it starts glitching, you’re pretty much on your own. It’s also truncated at 250 rows, so you wouldn’t be able to export an enormous project. The one we currently export contains 91 tasks and 96 subtasks, which equates to 188 rows.
In answer to your question about status, there’s no third dropdown option. When a task is completed, it still has the ‘In Progress’ status, but the fact that it has been marked as complete indicates that it’s done. In the Power BI report, my ‘In progress’ count is filtered for all tasks with ‘Completed At’ blank. So I’m only counting tasks that are in progress and have no completion date.
What I’d really love is an inbuilt, Asana-powered reporting system, similar to Power BI, but without having to leave Asana itself. Maybe someday.