SharePoint 2013 For Dummies
Book image
Explore Book Buy On Amazon

Column validation options allow you to define additional limits and constraints for your data. For example, you may want to ensure that a value in one Date column occurs after another Date column. (So for example, column validation can ensure that the date in the Date Finished column can’t be earlier than the date in the Date Started column — you can’t finish a project before it’s begun!)

To use column validation on your app:

  1. In your app where you want to validate data entry, click the List Settings button on the List tab of the Ribbon.

  2. Under General Settings, click the Validation Settings link.

  3. Type a formula in the Formula text box.

    The result of the formula must evaluate to TRUE to pass validation. The formula syntax is the same as calculated columns, which is similar to Excel syntax.

  4. Enter a user message that you want to appear if the validation formula fails.

    The message should give the user an idea of how the formula works and how to fix the problem.

  5. Click the Save button.


    When users enter data into your form, the validation formula is evaluated. If the formula evaluates to FALSE, your user message appears on the form.


You can add column validation to columns created at the app or site level. Validation created for site-level columns applies everywhere that column is used, although the formula can be overridden at the app where the site-level column is used.

About This Article

This article is from the book:

About the book author:

Ken Withee is a longtime Microsoft SharePoint consultant. He currently writes for Microsoft's TechNet and MSDN sites and is president of Portal Integrators LLC, a software development and services company. Ken wrote Microsoft Business Intelligence For Dummies and is coauthor of Office 365 For Dummies.

This article can be found in the category: