Just like column validation we can have validation formulas at list level. Column validation can only validate the current column and can not perform validation for other columns. For applying validation on multiple columns, you would need SharePoint’s List or Library level validation.
Why need List Validation
There is possibility that data entered in list fields is correct while submitting the form but entered value is not correct if compared with other values in the field.
The simplest is Start Date and End Date fields, user can enter date values properly in both fields but there is possibility of adding wrong date ranges. With the help of List validation, we can compare that End Date must be greater that Start Date.
Applying List Validation
For applying list validation, I have created two columns Start Date and End Date of datetime in my SharePoint lists. Follow below steps to do the list validatioj:
- Click on Gear icon and go to list settings (for older SharePoint version, select list settings from ribbon)
- Under General, click on Validation Settings
- Now select the fields form Insert Pane to the Formula Pane
- I have added date comparison formula as =[End Date] > [Start Date]
- Enter validation message in User Message pane.
- Save the changes
Now go to the list and add new item to validate the working of the list validation.