Export all projects in a team or Portfolio

Why is there no ability to run a simple status report for all projects in a team or portfolio?
What is needed is a simple report that can be exported to excel or similar - basically all the fields in a portfolio but that can be sent to a non asana user / to be included in a monthly department meeting.
Plenty of reports available for tasks, but not an overal project / team summary report.

2 Likes

@Dave_Thomas Some Asana integrations specialize in this kind of reporting, like Velocity, which lets you create very customizable reports that summarize projects and tasks.

You can also find more Asana reporting integrations in the Reporting category of the Asana App Directory.

(Disclosure: I’m a founder of Velocity.)

@Dave_Thomas, Were you aware of the built-in Portfolios > Google Sheets feature documented here: https://asana.com/guide/help/premium/portfolios#gl-google-sheets

Also, I’ve created a very flexible solution that’s kind of like Portfolios but with Timeline and not requiring Business Tier; PM me if interested:

OKR Tracking in Asana Use Cases

I spent time a few months ago designing a quite powerful and very flexible solution for my clients to handle either OKRs or Goals/KPIs (and initiatives generally), that is quick to implement and maintain weekly or monthly, and works company-wide with roll-ups at the company- and department-levels. An optional third tier, sub-department-level, is optionally available too. Unlike Portfolios which requires the Business tier, this solution only requires Premium, and it even offers a key feature–int…

Thanks,

Larry

2 Likes

Cheers, thats exactly it! Thanks

1 Like

Hi Tom,
Thanks, yes saw Velocity and like the look of it, it is just a shame that a project management tool doesnt include this as standard.

5 Likes

Sign of the times. Lots of apps try to stimulate their own marketplaces by reducing the common sense features to allow 3rd parties in. Frankly I think it’s lame but what are you going to do.

The fact that we can’t run the same search/report as we get in email every Friday is maddening.

1 Like

Exactly! I am taking the data out as Larry mentioned into Excel and then running pivots off that to give me something I can share. But why cant I just have the friday report available!

1 Like

I also wish we could have better reporting. My heart dropped when I was doing a status meeting and couldn’t print out a simple report showing what everyone has to do. This doesn’t seem right.

3 Likes

@StudioPlace_ArtsGrou,

As you know, Asana has very basic reporting, but if you’re on a paid plan, using Advanced Search/Reports and printing from there can help if you haven’t tried printing from there yet in Asana.

But almost 5000 folks are benefitting from Asana2Go (disclaimer: I’m the creator) which offers around 20 out-of-the-box standard reports for different uses:

Other third-party reporting solutions (though not free like Asana2Go) are listed at Asana Apps and Integrations • Asana.

Hope that helps until/if something is available natively in Asana,

Larry

1 Like

@Tom_Benner Does Velocity let you run a report on a specific Portfolio? All the reporting tools I look at seem to make you add a bunch of projects manually. Here is my use case:

*I group projects into portfolios

  • I add custom columns (numeric) to the portfolios
  • I fill out the columns for each project
  • I would like to generate a report on that data

The default Google Sheets sync is fine, but it’s a very manual process to create visualizations. Looking for something a little more intuitive that will let me drill down into the data in an interactive way.