
(Learn more about Control Center Limitations.) Repair a Summary Sheet Multiple Summary sheets can help you manage sheet limitations-useful when you are creating large numbers of projects. Each sheet might serve different audiences. You can have more than one Summary sheet with different profile data columns. You can connect the Blueprint to more than one Summary sheet. NOTE: Parent rows can include formulas to calculate metrics for the child projects. You’ll add this parent profile data element in the hierarchy section of the Blueprint Builder. To do this, add parent rows to your Summary Sheet. 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. Profile data values from your Project sheets will be cell-linked to matching columns in the Blueprint Summary sheet. Each project you create is automatically added to the associated Blueprint Summary. Add a Project to the Blueprint Summary SheetĬreate a new project. NOTE: 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.

To add columns that are not related to profile data, you can add those directly to the Blueprint Summary sheet.To add profile data columns, run the Blueprint Builder.How you edit the Blueprint Summary sheet will depend on what you want to do: If an element is used to calculate metrics or shows important project data, it’s a good choice for inclusion in your Blueprint Summary sheet. You may not want all of the profile data elements from your source templates in the Blueprint Summary sheet. Select the Profile Data Elements You Want Share it to other stakeholders who need to see it with Viewer-level permissions. A Primary Lead must own the Blueprint Summary sheet.If you’ve placed the Blueprint Summary in the Blueprint Source Folder, a new copy of it will be made automatically every time you create a new project.Place the Blueprint Summary sheet in your Admin workspace, not in the Blueprint Source Folder. This can be useful if you want to create metrics that use multiple data elements.

TIP: The Blueprint Summary sheet can include columns that don’t exist in your profile data.

(More on the Blueprint Builder is available here.)Īs you set up a Blueprint Summary sheet, you must create a column for each profile data element you want to include. Create a Blueprint Summary sheetĬreate a Blueprint Summary sheet before you run the Blueprint Builder. This feature helps you create (optional) overviews of all your projects-in one place.
