Required Field Validation Based on Another Column’s Value in SharePoint 2013

Requirement: In a custom SharePoint 2013 list, User’s requirement is to validate a required field based on another field’s value.

E.g. In a “Project Cost” list, the user must fill “Budget Amount” field value if “Budget Approved” field’s value is set to “True”.

How to make a field required based on another value in SharePoint?

Here is how to implement a required field validation based on other column’s value in SharePoint 2013.

  • Head on the List Settings
  • Click on “Validation Settings” under “General Settings”
  • Enter the validation formula as: =IF([Budget Approved?]=TRUE,IF([Budget Amount]=””,FALSE,TRUE),TRUE)
  • Enter the user (error) message accordingly. I’ve entered “If Budget is approved, you must specify the value of Budget Amount!”.sharepoint 2013 required field validation
  • Click “OK” to save your changes

and the result in action:
Required Field Validation Based on Another Column's Value in SharePoint 2013

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

2 thoughts on “Required Field Validation Based on Another Column’s Value in SharePoint 2013

  • January 16, 2016 at 12:53 AM

    I have a Sharepoint/Office 365 list with account names and created date. The list is used to track who we have invited to a survey, and we don’t want to resurvey within 90 days. I would like to create a validation (either list or column) that prevents the same account name from being entered if we have surveyed them in the last 90 days. It is OK to survey again after the 90 days has ended.

    I can think of many ways to do this in Excel but cannot figure out what rule or combination of rules is allowed in Sharepoint or whether this is even possible.

    Any help/guidance would be great.

    Reply
  • August 17, 2015 at 9:09 AM

    How do I get to the formula where:

    DATATYPES:

    COLUMN1-(YES/NO)
    COLUMN2- DATE AND TIME
    COLUMN3- CHOICE
    COLUMN4- MULTIPLE LINE OF TEXT (PLAIN)
    COLUMN5- PEOPLE

    The condition is:

    IF COLUMN1=”YES”
    THEN
    COLUMN2 NOT EQUAL TO BLANK
    COLUMN3 NOT EQUAL TO BLANK
    COLUMN4 NOT EQUAL TO BLANK
    COLUMN5 NOT EQUAL TO BLANK

    Please help.

    Reply

Leave a Reply