Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

Licensed users with an Owner or Admin permission on the sheet can use this capability.

Identify renamed sheet columns in reports

Your reports stay connected even when column names in underlying sheets have changed.

PLANS

  • Pro
  • Business
  • Enterprise

Permissions

Licensed users with an Owner or Admin permission on the sheet can use this capability.

You can rename the column on the report, go to the sheet to learn more, or disconnect it from the report.

A small icon alert in the Columns Displayed icon informs you when underlying column names have been changed. Use manage columns in the report builder to see what has changed.

For example, if a column on an underlying sheet was changed from Status to Progress, the renamed Progress column stays connected to the Status column in the report. Want to report the renamed columns separately? Disconnect the column and rebuild your report. 

To work with renamed columns:  

  1. At the top of the report in the report builder, select Columns
  2. Scroll to the column with changes. Any changes are indicated below the column name. 
  3. Hover over the non-matching column name. 
  4. 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. 
Was this article helpful?
YesNo