[You can customize the error message the way you want if you this validation than using the maximum and minimum settings 🙂 ] The formula is pretty similar to Excel.I also remember seeing some Share Point functions (in the early builds), but the help is currently unavailable so we have to wait till the public beta is released.
Column Validation In Share Point, now columns have a new section called Column Validation where you can enter formulas (similar to Excel formulas) to pass validation.
You can enter the formula and the corresponding message that you want to display to the users if the validation fails.
This error message is composed by following the steps mentioned earlier and shown in figure 5.
Figure 10: Error Alert (Date)In some cases, you want to force the user to enter values from a specific list.
If a value that is not in the list is typed then an error dialog is displayed as shown in figure 12 below.
Figure 12: Error Alert (List)There are several cool things that can be done with lists in Excel, for example, creating expandable lists, or dependent lists. If you want to restrict the length of a text entry you can do it as well.
This message is show near the cell if you want to move this pop up you can move it to another cell.
Let’s take an example and understand how we can validate text entries.
If user types less than 20 or more than 300 characters in B16 then an error dialog box will be displayed as shown in figure 14 below.
Figure 14: Error Alert (Text Length)On top of all the possible options shown for data validation, you can also use a formula that return a logical value to validate entries.
Data Validation is used for making the data error free in Microsoft Excel.