Monday, March 30, 2015

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, user must fill "Budget Amount" field value if "Budget Approved" field's value is set to "True".

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

  • Head on to 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



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

2 comments :

  1. 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.

    ReplyDelete
  2. 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.

    ReplyDelete

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...