Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Validate information in forms

With form validation, use the form builder to add real-time validation to your forms and help you gather consistent, error-free data.

Who can use this?

Plans:

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Add simple character and pattern-based validation to Text/Number and Contact List fields.

Validation typeField typesValid charactertsValid patterns
NumbersText/Number

Numbers

Period (.)

Dash (-)

“e” for exponential

N/A
PercentsText/Number

Numbers

Period (.)

Dash (-)

“e” for exponential

N/A
Email addressesText/Number, Contact ListAll[characters]@[characters].[characters]
Phone numbersText/NumberNumbersMust have correct number of characters based on selected country

The dash (-) symbol can only be used as a negative sign in a number validation field.

To use validation in your form

  1. Select Forms > Manage forms…
  2. Open an existing form. 
  3. Select a text/number or contact list field on your form to open the Field Settings panel on the right.
  4. Navigate to Validation in the panel. By default, No Validation is the selected option. 
  5. Select the option you want to enable for the field.
Brandfolder Image
Validation in forms

Fill in a form field with validation enabled

When filling in a field with validation, the submitter’s experience depends on the type of validation that you enabled:

  • If the validation requires certain types of characters, they can't enter any invalid characters in the field. For example, in a phone-validated field, they can't enter any non-numeric characters.
  • If the validation requires a certain character pattern, their entry must match that pattern. If they enter something that doesn't match the pattern and then click anywhere else on the form, the form displays an error message.

Notes to validate information in your form

  • When you add phone validation to a field on your form, you can select the default country code. However, people who fill out the form can change the country code while filling in the phone-validated field.
  • You can't submit a form with a validation error in it. The submitter first needs to fix the entry in the validated field or delete their entry (if the field is not required).
  • You can't use form validation in the mobile app. Use GPS/barcode functionality instead.