Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

  • Owner
  • Admin

Control data entry in a column

Add restrictions to your data entries in columns.  

Who can use this?

Plans:

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions:

  • Owner
  • Admin

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

In a sheet, you can use various column types to establish restrictions for data entry. Depending on the restrictions you set, you may still be able to type text or add a new value into a cell, even when a column property is in place.

For example, your sheet can have a checkbox column, however, collaborators can still add free texts and overwrite the checkbox.

The only columns you can't overwrite are the following system columns:

  • Auto number
  • Latest comment
  • Created by
  • Created date
  • Modified by
  • Modified date

Restrict column data to specific values

You can restrict data entry to specific values in the following columns:

  • Dropdown list
  • Dates
  • Contact list
  • Checkbox
  • Symbols

 

To restrict data in columns: 

  1. Right-click the column header or select the Column Menu  Brandfolder Image Kebab menu icon
  2. Select Edit Column Properties.
  3. Turn on the Restrict to toggle. 
Brandfolder Image
Edit Column Properties panel with restrict to values turned on

These same restrictions apply to any web forms associated with the sheet.

Owners and Admins can bypass data validation. They receive a warning message if they attempt to enter a different value from those specified as valid for the column.

 

Was this article helpful?
YesNo