Understanding and optimizing the mandatory primary column in your Smartsheet grid.
USM Content
Every sheet has a primary column. This column is mandatory, and you can't delete it from the sheet. The value in this column is frequently the row's primary descriptor.
When you create a new item in Smartsheet, the primary column is set automatically — in Grid View, it is the left-most column. When you create a new sheet by importing data from another program, you'll be asked to designate the primary column.
Double-click the column name to rename the primary column and type a new name.
Once the primary column is set, you can’t designate another column to be the primary.
If you want to change the contents of the primary column, you can insert a new column in your sheet, cut and paste the data in the cells from the existing primary column to this newly inserted column, and then paste the preferred data into the empty primary column.
Свойства столбца
With the exception of the column name, you can't change the properties of the primary column. Here's a list of the properties:
- The column name is in bold text (this is the only column name with this property)
- It's the column where you'll see expand and collapse buttons
/
when you create a hierarchy in your sheet. - The primary column type is always Text/Number. Auto number or other column types aren't available.
- The format for text and numbers in the column is left-justified.
Primary column name: Best practices
When you name the primary column, use a descriptive name: Client Name, Task Name, Order Number, Part Number, and so on.
The primary column identifies the row when you use features such as Send row or Request update.
A descriptive name helps you better communicate about the row or request information from other Smartsheet users.
Primary column name in reports
Because reports can return data from multiple sheets, each having a different primary column name, information from the primary column is consolidated into a single column named Primary.
Reports don't display hierarchy.
Primary columns in forms
Primary columns in forms have some restrictions when applying changes:
You can rename the primary column from the form but can’t change the Text/Number column type.
When you create a new form, the primary column is inherited from the intake sheet. You can add a new column with any column type that you need.
- If you don’t want to use the primary column in your form, you can deselect it from the Fields panel or delete it from your form canvas.
Can I add a primary column to an existing sheet?
No. You can’t add a second primary column or convert a different column into the primary column after a sheet is created. However, if you need to replace the contents of the primary column:
- Insert a new column next to the primary column.
- Select and cut the primary column's content.
- Paste that content into the new column (this preserves the original values).
- Enter your preferred new content into the now-empty primary column.
Can I change the primary column type?
No. The primary column type is always Text/Number. All other column types, including Auto-number, are unavailable for the primary column.
How do I recover cell data from my primary column?
If you deleted or cleared values from the primary column in a sheet, check your sheet's activity log or use Ctrl+Z / Cmd+Z immediately to undo.
- Open the sheet.
- Use Ctrl+Z / Cmd+Z to undo if the action was recent.
- If undo is no longer available, check if your sheet has a backup via the sheet's Activity Log or your workspace's version history.
If you frequently edit data through reports, consider locking the primary column in the source sheet to prevent accidental edits. Owners and Admins can do this under column properties.