Is there an option to add new Metadata to select Existing Projects using the SS Control Center?

08/28/20
Answered - Pending Review

When we created some new projects recently, we accidentally missed selecting a metadata (in the profile data) and hence some of our projects are missing this essential information.

In order to ensure that all our projects are consistent, I am looking to use the Global Update to add this metadata to these existing projects (100 projects) within a program (which consists of more than 2000 projects) in my Control Centre.

Currently, I only see options to introduce new metadata to new projects and no options to update select existing projects.

Does anyone have any experience with this issue?

Thank You.

Answers

  • Hi @Milan Mathias

    It sounds like you want to add a new field to your intake 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 new and 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

    1. In Smartsheet Control Center, navigate to Global Updates > New Update > Add Profile Data
    2. Name the new update, and select your blueprint
    3. 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
    4. Test your update and review the test sheet. The field should be added without a value
    5. On the Apply Global Update screen, be sure to check the check the checkboxes next to Apply update to the base project template(s) and Include Project Profile Data in reporting sheet if missing
    6. 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

    1. After the field is added to all existing projects, navigate to Manage Program > Blueprint editor > Customize Profile Data
    2. Click Add Field and add the new profile data field. Populate the field from the Intake Sheet
    3. Click Next to go to the Blueprint Summary editor. Be sure that the new field is included/checked in the Summary Data Fields section
    4. Continue through the Blueprint editor and save

    Step 4 - Generate the Cell Links

    1. Navigate to My Projects in SCC and click the project name
    2. Select Edit Project Information to configure the global fields
    3. Click Update. You'll see a message that you haven't made any changes. Click Yes to continue
    4. 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. 


    If you have any questions about this, it may be best to contact our Support team so they can clarify further and discuss this one-on-one with you for your specific account.

    As a Moderator I'm able to see that your account is eligible to book Pro Desk sessions which are screen-sharing coaching sessions. We have a category specifically for Control Center if you would like to walk through this with someone, see here: https://www.smartsheet.com/pro-desk

    Cheers!

    Genevieve

Sign In or Register to comment.