Share via

List Validation On Three Fields

Not Null 41 Reputation points
2020-08-12T23:11:18.38+00:00

I'm trying to figure out the formula to validate three fields but I'm having trouble getting it to work.

Logic:
If [Request Type] <> "Upcoming Project" and Department = "IT", then [Service Location] <> ""

If the Request Type is not Upcoming Project, Department is IT, then Service Location cannot be empty.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,868 questions
0 comments
Accepted answer
  1. Emily Du-MSFT 47,471 Reputation points Microsoft Vendor
    2020-08-13T08:07:54.443+00:00

    You could use following formula in the list validation settings.

    IF(AND([Request Type]<>"Upcoming Project", [Department]="IT"), IF([Service Location]<>"",TRUE,FALSE),TRUE)

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.