List Validation Settings in SharePoint

Validation Settings

To proceed to create a list with the following 2 columns:

  1. Budget as Number
  2. Amount as Number

edit in list

You can access those settings from List, then List Settings and by clicking the Validation Settings link.

Validation Settings link

Now you can set a validation that the Amount should not be greater than the Budget. You can see this below.

validation setting

Additionally, we have set a user message too.

Testing

Now let us try to create an invalid item. It will display an error message as in the following screenshot:

error message

You can change the amount to save the item.

Expense

Note

In the advanced scenarios we can come with AND and OR operators too.

Summary

In this article we have explored the List Validation Settings feature. In future articles I will write about more complex validations.