Pull Historical data back into Summary Sheet in Control Center?
I have added a new column to Metadata, How can I add historical project back into Summary Sheet?
Answers
-
Hi @KGill
It sounds like you want to add a new field to your intake sheet from a new column in your Metadata sheet that should also be pulled into the profile data on your
existing projects
, new projects going forward, and blueprint summary. In order to add new profile data from the intake sheet onto your newand
existing projects, take the following steps:Step 1 - Update the Intake Sheet
- In the intake sheet, add the columns you'd like to include as new profile data. Be sure to use the same names for the column that you plan to use across all of your sheets profile data
Step 2 - Global Updates
- In Smartsheet Control Center, navigate to Global Updates > New Update > Add Column
- Name the update, and select your blueprint
- Select the Metadata sheet, and "Use an Existing Column from the template" if you have already added the column, if not select "Create a new column".
- Follow the steps on the screen.
- Test your update and review the test sheet. The column should be added.
- Select all the projects you wish to update, and apply the updates. If any projects fail, run the global update a second time.
Now, for the next part!!
- In Smartsheet Control Center, navigate to Global Updates > New Update > Add Profile Data
- Name the new update, and select your blueprint
- Enter the field names for the new profile data, ensuring that the field names are the same as the column names in the intake sheet. Add as many fields as needed, but leave the value section blank
- Test your update and review the test sheet. The field should be added without a value
- On the Apply Global Update screen, be sure to check the check the checkboxes next to
Apply update to the base project template(s)
andInclude Project Profile Data in reporting sheet if missing
- Select all the projects you wish to update, and apply the updates. If any projects fail, run the global update a second time.
Step 3 - Update the Blueprint Summary
- After the field is added to all existing projects, navigate to Manage Program > Blueprint editor > Customize Profile Data
- Click
Add Field
and add the new profile data field. Populate the field from the Intake Sheet - Click Next to go to the Blueprint Summary editor. Be sure that the new field is included/checked in the Summary Data Fields section
- Continue through the Blueprint editor and save
Step 4 - Generate the Cell Links
- Navigate to My Projects in SCC and click the project name
- Select
Edit Project Information
to configure the global fields - Click
Update
. You'll see a message that you haven't made any changes. ClickYes
to continue - Repeat these steps for each project. Unfortunately, there is not a way to do this in bulk at this time.
Once you've completed the above steps, you can refresh or navigate to the updated projects to confirm that the profile data field is now present and cell linked to the Intake Sheet.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives