Control Center Global Updates: Columns

Applies to

Smartsheet

Control Center Global Updates allow you to make column changes to sheet templates and roll those changes out across all existing projects. Control Center offers the following options for making column-level changes to your project sheets and templates:

  • Add New Column
  • Modify Existing Column

Add a New Column

There are two ways to use Global Updates to add a new column. With either method, all projects in your Control Center portfolio benefit from the update.

You can:

  • Create a new column - Use Global Updates to create and add new columns to a template. This option adds the new column to the template. Then, run the Global Update to update existing projects.
  •  Use an existing column from a template - Use this option if you’ve already added a new column to the base template. Use Global Updates to add the new column to already deployed projects.
    TIP: Use this method to apply a column property (such as currency or decimal places) to an existing column. 

Option 1: Create a new column

  1. Navigate to Control Center > Manage Program > Global Updates and select Add New Column.
  2. Name your update, then select the blueprint and template you want to use.
  3. Check Create a new column (default) and enter the Column Title and Column Type.
    TIP: Select one of the default value options to define the values populated when you run the Global Update.
    (Optional) Select Advanced to display other options:  formatting, column position, and locked / hidden state. See Advanced Options in Global Updates to Columns for more information.
  4. Complete the Global Update to test and apply your changes. See Test and Validate Your Changes for more information. 

Option 2: Use an existing column from the template

If you manually added a new column to your base template, use this option to push the new column to already provisioned projects in your SCC portfolio. 

  1. Add the new column to your template and configure it as desired. See Columns for more information on available column types and their uses.
  2. Navigate to Control Center > Manage Program > Global Updates and select Add New Column.
  3. Name your update, then select the blueprint and template you want to use.
  4. Select Use an existing column.
  5. Select the column you created from the Add Column dropdown (Click refresh if you don’t see the new column).
    TIP: Select a default value to define values populated when you run the Global Update. Note that only one default value or formula can be applied per Global Update.
    (Optional) Select Advanced to display other options:  formatting, column position, and locked / hidden state. See Advanced Options in Global Updates to Columns (below) for more information.
  6. Complete the Global Update to test and apply your changes. See Test and Validate Your Changes for more information. 

For more information adding a column to a base template, see the Smartsheet Control Center FAQ.

Modify an Existing Column

Modify Existing Column allows you to change a column that already exists in your project sheets. You may want to modify existing columns to:

  • Adjust column formatting
  • Update a Dropdown column to remove or add options
  • Adjust references in a formula
  1. Navigate to Control Center > Manage Program > Global Updates and select Modify Existing Column.
  2. Name your update, then select the blueprint and template you want to use.
  3. Select the column you want to update, and enter the details for your update.
    NOTE: Select one (or both) of the options:
  4. Change column properties (name, type, options, index)
  5. Change column cell data. See Modifying Column Data below for more information.(Optional) Select Advanced to display other options you can apply to the column: formatting, column position, and locked / hidden state. See Advanced Options in Global Updates to Columns for more information.
  6. Complete the Global Update to test and apply your changes. See Test and Validate Your Changes for more information. 

Modifying Column Data

In addition to adding new data or changing column values, you can use Global Updates to make global changes to existing data in active projects.

  1. Create a Modify Existing Column update.
  2. Check Change column cell data.
  3. Select a value from the column and click Add New Change.
  4. Enter a new static value or formula. See Formula Requirements for more information.

NOTE: Formulas created in Global Updates must use @row notations for row level referencing. For more information, see Create Efficient Formulas with @cell and @row. 

Advanced Options in Global Updates to Columns

Here are some things to keep in mind when using advanced options:

  • When adjusting Column Position, note that you cannot add a column between the Primary Column and the column immediately to the right of it. This positioning restriction is enforced because this is where Profile Data name and value pairs are stored.
  • While formatting that’s been explicitly applied to the column will be pushed to existing projects, Conditional Formatting rules will not be copied to the project sheets.
  • Certain formatting options are not available in Advanced Options. These include:
    • Currency
    • Percentage
    • Thousands separator
    • Decimal places
    • Date format

TIP: If you want to apply any of the above to your projects, update your source templates. All newly provisioned projects will include the new formatting. After updating source templates, to update existing projects, use Option 2: Use an existing column from the template.