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!".
- Click "OK" to save your changes
You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.