Field Validation

Set validation rules on columns to ensure data quality. Validation prevents bad data from entering your table: required fields that can't be empty, numbers within ranges, text matching patterns, and custom formula-based rules.

Setting up validation

1. Click the column header → Column settings (or right-click → Settings)
2. Go to the Validation section
3. Add one or more validation rules
4. Click Save

Available validation rules

Required

Text validation

Number validation

Date validation

Choice validation

Custom formula validation

Write a formula that must evaluate to true:

// Value must be a valid US phone format
REGEX(value, "^\\+1\\d{10}$")

// End date must be after start date
{End Date} > {Start Date}

// Budget must be in multiples of 100
MOD(value, 100) == 0

// At least one contact method required
NOT(AND(ISEMPTY({Email}), ISEMPTY({Phone})))

Validation behavior

When validation runs

Error display

When validation fails:

• The cell border turns red
• An error message appears below the field: "Value must be between 0 and 100"
• The change is not saved until the error is fixed
• Other cells can still be edited; validation is per-cell

Bulk validation

When importing CSV data or pasting multiple rows:

1. All rows are validated before import
2. Invalid rows are flagged with the specific error
3. You can choose to:
   • Skip invalid rows: import only valid rows
   • Fix and retry: edit invalid values and retry
   • Import all: import with errors (validation warnings but data is saved)

Common validation patterns