Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

  • Owner
  • Admin

Change column details

Adjusting column attributes for enhanced data management

Who can use this?

Plans:

  • Pro
  • Business
  • Enterprise

Permissions:

  • Owner
  • Admin

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

Column types help ensure incoming data has real meaning for sheet users. Column descriptions provide context and essential details on how to use the data. Here, you'll learn how to update a column's type and description.

 

If you're the sheet Owner or Admin, you can prevent others from adding free text to column cells or form fields.

 


Change a column's type

Sheets have a rich assortment of column types. See Column types for details.

You can't change the column type of a primary column or project settings column.

 

  1. Access the column properties. Either double-click the column header
    Or,
    Hover over the column header, select the Column Menu the Column Menu icon, and then select Edit Column Properties.
  2. Select a different type from the Column Type menu in the column properties panel.
  3. Select Ok.

Include a column description

Explain important information about a column to show as a tooltip. For example, use a column description to document what type of data you expect the column to contain.

  1. Right-click a column header. 
  2. Select Add Column Description...
  3. In the Column Description field that appears, describe the column. 

    The description can be up to 250 characters long.
  4. Select OK.  

That's it! Now, anyone shared to the sheet can view the description by hovering over the column.

View the column description

 

You can't view column descriptions in reports and dashboards. Column descriptions appear in sheets only.

 

You'll know a column has a description if you see this icon: the information icon.

To view the column description, hover over the information icon  the information icon. The column's description appears.
An image of the tooltip

Edit column description information

  1. Right-click the column header.
  2. Select Edit Column Description.
  3. In the Column Description form, make your desired changes. 
  4. Select OK.

Your new description is live.

Was this article helpful?
YesNo