# Validation

#### Introduction

You can setup validation rules to flag any content errors within your sheets.

#### Usage

Validation rules can be configured per column in the Schema settings page. For example, if you setup the following column definition ...

<figure><img src="https://3212093605-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTDwmfyeZRuajecSvhNn5%2Fuploads%2F3KBLjVZC82CCZgYBJTge%2Fimage.png?alt=media&#x26;token=1a0ab792-5a84-4add-aa3c-2ea008ba1b89" alt=""><figcaption></figcaption></figure>

then any cells under the "SKU" column and containing spaces will be flagged like below ...

<figure><img src="https://3212093605-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTDwmfyeZRuajecSvhNn5%2Fuploads%2Fty1W4qm6TqILAEmKm4A5%2Fimage.png?alt=media&#x26;token=95f5b980-3ec8-4b27-ac24-0fffe46bf015" alt=""><figcaption></figcaption></figure>

Clicking the alert icon (<img src="https://3212093605-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTDwmfyeZRuajecSvhNn5%2Fuploads%2FoMLYVU2d48LxjYSwnY2S%2Fimage.png?alt=media&#x26;token=d7760aa8-5e0c-45e9-a470-eaa1fd2ecc1a" alt="" data-size="line">) will show a popup with more information on the validation error ...

<figure><img src="https://3212093605-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTDwmfyeZRuajecSvhNn5%2Fuploads%2Fr3HjBGWBsV70CedTvWJp%2Fimage.png?alt=media&#x26;token=bed59e4e-9e0b-4543-adff-0b24694e58b2" alt=""><figcaption></figcaption></figure>

This particular rule supports auto-correction so the error can be corrected automatically by clicking "Fix".

There are currently two built-in validation rules:

1. "No Spaces"; checks for and corrects spaces in input
2. "No Accents"; checks for and removes letter accents
3. "Lower Case"; checks that input is in lower case
4. "Title Case"; checks that input is in title case

#### Supported Column Types

Validation is currently limited to the following types:

1. `Text`
2. `Single Select`
3. `Rich Text (HTML)`