Using Partial Data to Create a Report
Hi,
I have a Project Plan Tracking document that contains data from several different projects in progress. My question lies in wanting to create a report for one of the aforementioned projects. I will call it Project A
The problem lies where I cannot create a report for Project A without including the data from the other projects within the Project Plan tracking document.
I have used a workaround by adding a column with a numbering convention that I can filter by. The issue with that is that I have to create several tracking documents in order to filter correctly, which i is cumbersome.
Is there an easier way to achieve the desired result?
Any assistance would be greatly appreciated.
Thank you,
Answers
-
Hi,
It sounds you are working with a Portfolio Overview Sheet where each row is a project, and you want to extract data from a unique Project (row) to create a separate report.
You should create a separate sheet (Project Metadata) for each project and make your individual report from it. On each of this new sheet you create a number of columns, the same number as in your Portfolio Overview. You also need to include a row with the name of all the columns you need data from. Then use INDEX MATCH functions based on project ID number/name and column names to import your data from the Overview.
It will look something like this.
Check the PMO template from Smartsheet as it has the templates you need. Setup: Project Management Office - Smartsheet.com
Hope it helps,
Antonio
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives