Portfolio Reporting

APPLIES TO

  • Smartsheet Advance Package

Display and act on critical portfolio data in real time with easy-to-configure, widget-based views that automatically include data from newly created projects.

Smartsheet Control Center: Set up a blueprint summary sheet

APPLIES TO

  • Smartsheet Advance Package

In a blueprint summary sheet, you can also track: 

  • Total number of projects in a particular phase
  • Total budget for all the projects
  • Health and forecast completion date for each project 

This feature helps you create (optional) overviews of all your projects—in one place.

Create a blueprint summary sheet

Create a blueprint summary sheet before you run the blueprint builder.

As you set up a blueprint summary sheet, you must create a column for each profile data element you want to include. Here are some things to keep in mind as you do this:

  • The column name must be the same name as the profile data element in your source templates. 
  • For each column, select a type that matches the profile data element type (Text/Number, Contact List, Date, Dropdown list, Checkbox, Symbol, Auto-Number/System). 
  • Don't enable the Restrict to certain values only option in the sheet column properties for dropdowns, contact lists, or symbols. This can cause errors. 

 

The blueprint summary sheet can include columns that don’t exist in your profile data. This can be useful if you want to create metrics that use multiple data elements. 

 

Blueprint summary

Organize the blueprint summary

Place the blueprint summary sheet in your Admin workspace, not in the blueprint source folder. 

Keep these notes in mind:  

  • If you’ve placed the blueprint summary in the blueprint source folder, the system automatically creates a new copy of it every time you create a new project. 
  • A Primary Lead must own the blueprint summary sheet. Share it to other stakeholders who need to see it with Viewer-level permissions.

Select the profile data elements you want

You may not want all of the profile data elements from your source templates in the blueprint summary sheet.

If an element is used to calculate metrics or shows important project data, include it in your blueprint summary sheet. 

Edit a blueprint summary sheet

How you edit the blueprint summary sheet depends on what you want to do:

  • To add profile data columns, run the blueprint builder.
  • To add columns that aren't related to profile data, add those directly to the blueprint summary sheet. 
  • To delete or rename a column, edit the blueprint summary sheet.

 

If you change the name of a profile data element in the blueprint source template, you must also change it manually in the summary sheet.

 

Add a project to the blueprint summary sheet

Create a new project. Each project you create is automatically added to the associated blueprint summary. Profile data values from your project sheets are cell-linked to matching columns in the blueprint summary sheet.

Organize projects in a hierarchy

You can create a hierarchy in the summary sheet and configure the blueprint (in the Control Center app) to add new projects under the selected heading.

To do this, add parent rows to your summary sheet. You can add this parent profile data element in the hierarchy section of the blueprint builder.

Hierarchy in a Blueprint Summary Sheet

 

Parent rows can include formulas to calculate metrics for the child projects.

 

Work with multiple summary sheets

You can connect the blueprint to more than one summary sheet.

You can have more than one Summary sheet with different profile data columns. Each sheet might serve different audiences. Multiple summary sheets can help you manage sheet limitations, which is useful when you're creating large numbers of projects.

Repair a summary sheet

If a cell-link or row is accidentally deleted from the summary sheet, you can repair the cell-links connecting the project to the summary sheet. 

To repair a summary sheet:

  1. In Control Center, select Active Projects from the dropdown in the top right corner. 
  2. Select the project that needs repair.
  3. Click Update Reporting at the bottom of the screen. 
  4. A confirmation message appears when the update is complete. 

Display high-level data on a dashboard

Blueprint summary sheets contain raw data about all the projects that are using the specific blueprint. For a more high-level view:

  1. Create a second sheet for portfolio metrics and use cross-sheet formulas to calculate metrics about your projects. 
  2. Use a metric widget to add data from both your blueprint summary and your portfolio metrics to a dashboard to see important information about your program.
Video MP4