Identify renamed sheet columns in reports

Your reports stay connected even when column names in the underlying sheets change.

Who can use this?

Plans:

  • Pro
  • Business
  • Enterprise

Permissions:

  • Owner
  • Admin

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

A small icon alert in the affected column indicates when the underlying column names have changed. You can hover over it to see what changed and decide whether to rename the column on the report, go to the sheet to learn more, or disconnect it from the report. Learn how to select columns included in a report.

Identify renamed columns

For example, if a column on an underlying sheet is renamed from Status to Progress, the renamed Progress column remains linked to the Status column in the report. If you want to report the renamed columns separately, you need to disconnect the column and rebuild your report. 

Work with renamed columns 

  1. At the top of the report in the report builder, select Columns. 
  2. Scroll to the column with changes. You can see any changes below the column name. 

  3. Hover over the non-matching column name and select the Kebab  Data Shuttle kebab menu  menu on the right. Two options displayed:

    • Select Disconnect from report column to remove the column from the report.
    • Select Open source sheet to inspect the data. You can also rename the column in your report if you want to keep the naming consistent across sources.
    Disconnect from report option

    That's it! You're ready to continue working now that your data is consistent.