Insert, delete, or rename columns

Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

To insert, rename, or delete a column, you'll need a Smartsheet license and Owner-level or Admin-level sharing permissions to the sheet.

 

A sheet can contain up to 400 columns, 20,000 rows, or 500,000 cells (whichever limit is reached first). 

Read on to learn how to insert, delete, or rename columns in your sheet. 

You can undo any action until you save your changes.

Insert a new column

  1. In your sheet, hover your pointer over a column header. 
  2. Select Column Menu Column Menu icon.
  3. In the Column Menu, select Insert Column Right or Insert Column Left
  4. In the Insert Column form, identify the following:
    • Name: In the Name field, add the label you want for the new column.
      You can enter a column name with up to 50 characters. 
    • Column type: In the Column Type field, identify the kind of column you want to add.
      • Text/Number 
      • Dropdown list 
      • Duration 
      • Date 
      • Contact list 
      • Checkbox 
      • Symbols 
      • Auto number 
      • Created by 
      • Created date 
      • Latest Comment 
      • Modified by 
      • Modified date
  5. Select OK.

After doing these steps, the new column will appear to the left or right of the selected column.

Insert multiple columns at once

  1. Highlight the number of columns you'd like to insert.
    To highlight a number of columns, press and hold the Ctrl key (or command key, if you’re on a Mac device). Then select column headers one by one.
  2. Hover your pointer over the column header of any column you highlighted. 
  3. Select Column Menu Column Menu icon .
  4. In the Column Menu, select Insert x Columns Left or Insert x Columns Right.

The columns you insert will have a default name and column type:  

  • Name: Column [number of column] 
    • For example: Column12
  • Column type: Text/Number 

To change the column settings: 

  1. Double-click the column header.
  2. In the Edit Column Properties form, change the values in the following fields:
    • Name
    • Column Type

Change the column width

If you're not satisfied with the column width, you can adjust it. Note that you can’t modify the width of default columns (attachments, discussions, indicators). 

To change the column width:

  1. Hover your pointer over the column header's side border. 
  2. When the pointer becomes a double-headed arrow icon, adjust the width accordingly. 

Delete a column

Columns can be removed/deleted completely. However, you can’t delete these default columns:

  • Attachments
  • Comments
  • Proofs
  • Row Action Indicators 

You have three options:

  • Delete a single column
  • Delete multiple columns
  • Hide columns (if they’re default columns and can’t be deleted)

To delete a single column

  1.  Hover your pointer over the column header of the column you want to delete.
  2. Select Column Menu Column Menu icon
  3. In the Column Menu, select Delete Column.

To delete multiple columns

  1. Press and hold the Ctrl key (or the command key, if you’re on a Mac device). 
  2. Select up to five column headers.
  3. Hover your pointer over the column header of any of the highlighted columns. 
  4. Select Column Menu Column Menu icon
  5. In the Column Menu, select Delete Column.

To clear the content from a column without deleting it 

  1. Select a column or multiple columns. 
  2. Press the Backspace or Delete key on your keyboard.

Rename a column

If you include a column in reports, changing the column's name will exclude it from those reports. You'll need to replace the column in your report criteria

To rename a column

  1. Hover your pointer over the column header. 
  2. Select Column Menu Column Menu icon
  3. In the Column Menu, select Rename Column.
    You can also double-click the column header to open the Column Properties form.
  4. In the Name field of the Column Properties form, edit the column name.
  5. After editing the column name, select OK.