We’re looking at how we might be able to pull data from each project in a portfolio and have that data automatically update to either a new portfolio, or in the portfolio view.
Example: have the last summary from each project pull to a status. We’d also like the project description to pull in a similar fashion.
We’d also like the start and end dates to automatically pull to this view as well. Currently we can get Start, Launch, Complete or Go Live, but not the range option.
Because we also have to use SmartSheets as the entire company hasn’t switched to Asana, we’re trying to get a similar look to SmartSheets, so we can export the Asana project overview data to SmartSheets to have a combined view of all projects.
Also is there a way to set the Status to update based on task completion or those that are past due?
Does anyone have any ideas?