Home > SharePoint, SharePoint 2010, SharePoint 2013, SharePoint Online > SharePoint 2013 – List Validation

SharePoint 2013 – List Validation

One of my friend recently asked me how to apply list validation in SharePoint 2013. I explained him and thought of documenting it so others can use it for reference.

To start with I am trying to enforce the following requirement

There is a list with 3 choice columns “A”, “B”, and “C”. In any of these columns a value = “None” is not allowed.

Solution

Open list setting

ListValidation1

Click on Validation Settings

ListValidation2

Now you can apply formula and a message which will appear if validation fails

ListValidation3

Formula uses the IF condition for validation. The general syntax is IF(condition, true case, false case).
First we will check if column “A” is not equal to “None”, then only go and validate “B”. The same logic is applied for validating “B” and then “C”

ListValidation4

Advertisements
  1. Basanth
    February 11, 2015 at 4:34 PM

    Thanks this is exactly what i need to do I am using SP on Office365 & I am not able to see the validation settings under “General Settings” I only have the below options. Please advise.

    General Settings

    List name, description and navigation
    Versioning settings
    Advanced settings
    Audience targeting settings
    Rating settings
    Form settings

    Thanks
    Basanth

  2. Tracy Williams
    April 24, 2015 at 10:15 PM

    I’m trying to validate on a SharePoint 2013 Survey and don’t know the correct formula to use. I want users to enter the last 8 characters of a VIN#, which contains both alpha & numeric characters, but sometimes they only enter 4.

    I’m using the single line of text field, and it does allow validation on the field, but it doesn’t provide help on validation formulas. Can you help me?

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: