A blueprint is a repeatable set of sheets, reports, and dashboards that make up a project.
Smartsheet Control Center: Create a Blueprint
Blueprints provide the basic structure for the projects and processes that drive your organization. Blueprints save time and effort by automating the creation of new Smartsheet items.
A Blueprint Source Folder is required, and must contain at least one sheet, report, or dashboard to serve as the source template for your Blueprint. For more information, see Blueprint Source Folder Overview.
- Create your Blueprint Source Folder.
- Select Manage Program and click + New Blueprint.
- Use the Blueprint wizard to configure the Blueprint.
When creating a project, where do you want to store the generated items?
- New workspace for each project—Best if you need to change sharing permissions to items for each new project.
- Preselected workspace—All new projects are created in the same workspace. Everyone who can access that workspace has access both prior and newly created projects.
- Enable users to select workspace—The person creating the project has the ability to choose which workspace it’s created in. Use this to group projects, for example, if you want to group projects by regions.
- Enable users to select or create workspace—The person creating the project can select an existing workspace or create a new workspace for the project.
A Blueprint Source Folder is a requirement when setting up your program. This screen refers to that folder, and the sheets, reports, and dashboards inside that folder.
Learn more about Blueprint Source Folders.
These settings determine if an item in your Blueprint Source Folder is included in a project, if it’s required, and which sheet launches when you select the project in Control Center. Hover on the row to change which item is your launch sheet.
Optional templates have additional settings:
- Optional - Selected—Uncheck items that you want to exclude from your new project. (All items will be checked by default.) For example, you might have a Project Governance sheet that’s required for projects over $10,000. Lower budget projects won’t need this optional sheet.
- Optional - Unselected—Check items that you want to exclude from your new project. (All items will be unchecked by default.) For example, you may have an onboarding sheet for new clients, but a project for an existing client doesn’t need that sheet.
NOTE: Reports can not be configured as Optional. They are only available as Required templates.
If your project uses different versions of the same template, you can group those templates and then select the one you want to use when you create a project. For example, maybe you have two versions of a task list: a fast track and a normal track.
Type a group name (for example, Track) for each template in the group. Set one as selected—the one you use most often— and deselect the rest. You must have at least one selected template in the group as the default optional template.
Advanced Options for each item include:
- Add a Description—Important information to help guide your team on the use of the item.
- Allow Attachments—Grant or restrict the ability for people to attach files to items in the project. For example, if there’s a feasibility study for a project, you can include it when you create that project.
If your program includes an Intake Sheet or a Summary Sheet (more on Summary Sheets), you can include those items in your project on the Blueprint Components screen. You can enable the following items for all new projects:
- Intake sheet
- Summary rollup
- Dynamic report scope
- Include in WorkApp
Options listed here map to columns in your Intake Sheet. They tell your Blueprint which columns and values to read when you create a new project.
Optional advanced options include:
- Project Link Column—Adds a link to the default project sheet on a selected Intake sheet with a direct link to your Project after it has been created.
- Intake Attachments—If the project row on the Intake Sheet has attachments, you can select which sheets those attachments should be copied to.
- Additional Filters—Filter on specific columns when you create new projects. For example, you may to filter on Department so only projects in the Facilities Department appear when you select a project. If enabled, the Additional Filters appears in the Create Project wizard on the Profile Data screen. Whoever is creating a new project can set the filters to change what projects are available in the Select Project dropdown.
Profile Data Selection
Elements from the Summary section of your templates are listed here. These items are also pulled from your Intake Sheet. When you select an item here, it’s used as Profile Data when you create a new project. This ensures that your Profile Data is always consistent.
When you create a new project, you’ll provide the information that populates these fields.
Profile Data that on both the intake sheet and Blueprint templates is automatically selected.
You can customize where Intake Profile Data comes from when you create a project, set up validation rules, and apply other options.
For each field, select an answer to How is data being populated in this field?
- Value from intake sheet—Automatically use the value from the matching column in your Intake sheet
- User entered manually—Select the data type you will enter when creating a project. There are multiple data types to select from, including Date, Number, and two types of Dropdown lists. If you want to use dynamic Dropdown lists, be sure to create a regular Dropdown first.
If you included a Blueprint Summary, you can configure how project Profile Data will be linked to your Blueprint Summary sheets.
Select the Blueprint Summary sheet you created when you set up your project.
Summary Data Sources: Select which sheets should have Profile Data linked to the Blueprint Summary sheet. If more than one sheet is selected, choose as a Primary. The Primary sheet, determines which Profile Data has priority in cases where Profile Data exists on more than one sheet.
Summary Data Fields: Profile Data in selected Data Sources that match column names in the Blueprint Summary sheet are automatically included and required.
Additional Profile Data can be added. When you include a data element, Control Center adds a column to the Blueprint Summary.
Note: To remove a data element, open the Blueprint Summary sheet and manually delete or rename the column.
Row Hierarchy: Use this to determine how you want new rows inserted into your Blueprint Summary.
Up to three Profile Data elements may be specified—for up to three levels of hierarchy. If no matching parent row is found, the row will be added to the end of the sheet.
Leave this blank to add new rows to the end of the Blueprint Summary sheet.
+New Summary Sheet: Control Center starts with one Summary Sheet, but you can add more. They’re helpful for:
- Controlling access: One summary sheet can contain financials, accessible to a limited group, another may contain status information accessible by a wider audience.
- Storing large numbers of projects: Limits apply to how many rows a Blueprint Summary can hold. Distributing Profile Data across multiple sheets gives you more space.
Note: Project Archiving can free up space on Blueprint Summary sheets.
Intake Summary Sheet Update
You can link up to twenty profile data fields in your project to the Intake sheet. This is useful if a project has few metrics and you want to have them available on the Intake sheet.
Only one sheet can be linked to the Intake Sheet.
Use naming rules to help differentiate your projects. Select up to three Profile Elements to append to the name of each sheet in the project.
By default the project workspace will use these same rules.
These settings determine who—and what level access—each member of your project team has to the projects you create using this Blueprint.
Permissions: Smartsheet items must have a single owner, either be the Primary Lead or the Project Creator. Use Primary Lead as the default. Program Leads will have Admin permission.
Sharing: Additional users and groups may have different levels of permission on the project. These are in addition to permissions that already exist on the workspace. Users or groups granted permissions in Sharing have access to all items in the project.
Projects can be shared with users specified in Intake Profile Data. This is configured as part of the Customize Profile Data screen.
Advanced: Use the advanced section to share a specific templates with a user or group, rather than sharing the entire project.
Click Save in the lower-right corner of the wizard save your Blueprint. You can now edit your Blueprint, delete it, or create new projects.