Skip to content
Amal Hashim
All posts
Article

SharePoint 2013 - List Validation

Use list validation settings and an IF formula to stop users saving items where any of three choice columns is set to None.

1 min read#SharePoint#SharePoint 2013

A friend recently asked how to apply list validation in SharePoint 2013, so here are the steps.

The requirement: a list has three choice columns, "A", "B" and "C". None of them may be saved with the value "None".

Steps

  1. Open the list settings.

The list settings page

  1. Click Validation Settings.

The Validation Settings link

  1. Enter a formula and a message that appears when validation fails.

The validation formula and user message fields

The formula uses IF. The general syntax is IF(condition, true case, false case). First check that column "A" is not "None". Only then validate "B", and the same logic applies to "C".

The completed validation formula

Example

An item with A = "Yes", B = "None", C = "No" is rejected and shows your message. An item with no "None" in any column saves normally.