In this article we can explore List Validation Settings that is a less commonly used feature in SharePoint.
Validation SettingsTo proceed to create a list with the following 2 columns:
You can access those settings from List, then List Settings and by clicking the Validation Settings link.Now you can set a validation that the Amount should not be greater than the Budget. You can see this below.Additionally, we have set a user message too.TestingNow let us try to create an invalid item. It will display an error message as in the following screenshot:You can change the amount to save the item.NoteIn the advanced scenarios we can come with AND and OR operators too.SummaryIn this article we have explored the List Validation Settings feature. In future articles I will write about more complex validations.
SharePoint Online And Office 365 Administration