Control Center Global Updates: Profile Data

Applies to

Smartsheet Advance Package

Project profile data serves as high-level information for projects in your portfolio. Use Profile Data to:

  • Define the project with values such as Project Name, Description, Owner, Budget, Due Date
  • Create status tracking metrics or KPIs with values such as % Complete, Forecast End Date, Project Health 

Use this feature to add new Profile Data to your templates and existing projects. You can specify static values or create a formula to track a specific metric. For example, you can create a formula to count all at-risk tasks.

Add new Profile Data in your Control Center portfolio

  1. Go to Control Center > Manage Program > Global Updates and select Add Profile Data.
  2. Name your update, then select the blueprint and template you want to use.
  3. Apply the following optional settings. These settings are active by default.
  • Add profile data to source template and all future projects:  Adds profile data to your base template and to the Blueprint configuration. All projects created after this update will include the new profile data. 
     
  • Add missing profile data to the summary sheet:  Adds new profile data to the profile data column in the summary reporting sheet. If there is no matching column in the summary sheet, Control Center automatically creates a new column. ​​​This option also creates cell links from profile data in the project sheet to profile data in the summary sheet.
     
  • Link project profile data from intake sheet to project sheet:  Reads the profile data value from the intake sheet and adds it to the project sheet. Select Cell Link or One Time Write.
    • Cell link generates a link from the intake sheet profile data field value to the project sheet’s profile data field. Any changes on the intake sheet will automatically appear on the project sheet. 
    • One time write reads the profile data value from the intake sheet and updates it in the project sheet without creating a cell link between them. If you change this field in the intake sheet, it will not update the project sheet. 
    If you uncheck this option, those with access to the project sheet can manually enter a text value or formula.
  1. Complete the Global Update to test and apply your changes. See Test and Validate Your Changes for more information.

    You won't see cell links when you test your new update. Enter the date you’d expect to see and specify if the value is text or formula.

When the Global Update is complete, the new Profile Data fields appear in project sheets and templates in the summary hierarchy in those sheets.

You can also run global Find/Replace updates on Profile Data fields. Learn more about using global updates for find and replace