Validation Settings In SharePoint 2013

Without testing of our product, we can't send it to the market. If the software is not fit to business needs, it's worthless.  Before selling our product, we have to execute it many times becuase we have to find out the errors.
After completion of developement, we have to set the validation in all the areas becuase it shoud be user friendly and  flexible in the market. 
Similarly in our Application also, we will set validation in all the lists and the libraries. There are few out of box validation and custom validations in SharePoint.  Please look into the steps given below for all validation fields.
Example - Required Field Validation

Open your list and click List Settings in top of the menu.

Step 2

Under Columns section, click any Columns.


Next page will come. Look for 'Require that this column contains information' and check  Yes.
Step 4

Go to your list and click New and try to add a record. Do not enter any value in the last column.

This is the simple required field validation SharePoint List.

Example Date Validation
Validation to check your date of birth and it will compare to today's date. We will validate the date of birth and it must be earlier than the current date.

Open your List and go to your List settings -> click your columns.  
Now, expand the column validation, go to Next page and write your logic here.

TODAY() : it will consider  Today's date.

If you are entering today's date in B day column, you will get an error.
Example Email Validation 


You can create a column name like Email and data type shoud be Single Line text. Go to formula section and write your code.

Validate If the Entered Text is Number    
  1. =ISNUMBER([My Column]+0)  

Field must contain  fixed length or only two symbols

  1. =LEN(Number)=2  
Only no with fixed length 
  1. =IF(LEN(CustomSortOrder)=2,ISNUMBER(CustomSortOrder+0),FALSE)  
Required atleast one field
  1. =COUNTA([Name],[Phone])>=1  

Validate Email Address Column 
  1. =AND(  
  2.     ISERROR(FIND(" ", [Email],1)),  
  3.     IF(ISERROR(FIND("@", [Email],2)),  
  4.         FALSE,  
  5.         AND(  
  6.             ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),  
  7.             IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),  
  8.                 FALSE,  
  9.                 FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])  
  10.             )  
  11.         )  
  12.     )  
  13. )  
ValidatePhone No Column 
  1. =AND(  
  2.     LEN([PhoneNo])=14,  
  3.     IF(ISERROR(FIND("(", [PhoneNo],1)),  
  4.         FALSE,  
  5.         (FIND("(", [PhoneNo]) = 1)  
  6.     ),  
  7.     IF(ISERROR(FIND(")", [PhoneNo],5)),  
  8.         FALSE,  
  9.         (FIND(")", [PhoneNo], 5) = 5)  
  10.     ),  
  11.     IF(ISERROR(FIND(" ", [PhoneNo],6)),  
  12.         FALSE,  
  13.         (FIND(" ", [PhoneNo], 6) = 6)  
  14.     ),  
  15.     IF(ISERROR(FIND("-", [PhoneNo],10)),  
  16.         FALSE,  
  17.         (FIND("-", [PhoneNo], 10) = 10)  
  18.     ),  
  19.     IF(ISERROR(1*CONCATENATE(MID([PhoneNo], 2, 3), MID([PhoneNo], 7, 3), MID([PhoneNo], 11, 4))),  
  20.         FALSE,  
  21.         AND(  
  22.             1*CONCATENATE(MID([PhoneNo], 2, 3), MID([PhoneNo], 7, 3), MID(PhoneNo], 11, 4)) > 1000000000,  
  23.             1*MID([PhoneNo], 2, 3) <> 911,  
  24.             1*MID([PhoneNo], 7, 3) <> 911,  
  25.             1*MID([PhoneNo], 7, 3) <> 555  
  26.         )  
  27.     )  
  28. )  
Condition between two fields
  1. =IF([x],IF([y]<>"",TRUE,FALSE),TRUE)  
Validate Zip code 
  1. =OR([ZIP/Postal Code]="",LEN([ZIP/Postal Code])=5,AND(EXACT(UPPER([ZIP/Postal Code]),LOWER([ZIP/Postal Code])), LEN([ZIP/Postal Code])=10,NOT(ISERROR(FIND("-",[ZIP/Postal Code],6)))))  
Validate Date 
  1. =EXACT(UPPER(TEXT(LongDate,"MM/DD/YYYY")),LOWER(LongDate))  
You can use the formula given above in SharePoint list or library. In order to create the validation, you have to follow the steps given below.
  1. Navigate to your list.
  2. Select List Tools.
  3. Select List.
  4. Select List settings.
  5. Select Validation settings.
  6. Use the above formula.
  7. Set your user message (Hello World).
  8. Complete.

Up Next
    Ebook Download
    View all
    View all
    Rotary International is an international service organization whose stated purpose is to bring toget