0

I have a List with multiple columns and want to do validation on 2 columns based on the value of a drop-down list and want to do validation on the list with the following conditions.

Column 1 ( Type ) if value ( others ) is selected then the field shouldn't be blank

Column 2 ( Location ) if value ( others ) is selected then the field shouldn't be blank

I am able to do only one condition at a time with this formula:

=IF([Type]="Others",IF([Other Type]="",FALSE,TRUE),TRUE)

Can you advise what will be the formula that will have both conditions?

Improve this question
1
  • Are you trying to make one field mandatory for both conditions or two separate fields?
    – Ganesh Sanap - MVP
    Commented Mar 15, 2022 at 5:22

1 Answer 1

Reset to default
0

If you are trying to make the single field ([Other Type]) mandatory based on both conditions, you can use formula like:

=IF(OR([Type] = "Others", [Location] = "Others"), IF([Other Type] = "", FALSE, TRUE), TRUE)

If you are trying to make the two separate fields ([Other Type], [Other Location Type]) mandatory based on both conditions, you can try formula like:

=IF(OR(AND([Type] = "Others", [Other Type] = ""), AND([Location] = "Others", [Other Location Type] = "")), FALSE, TRUE)

Documentation: Examples of common formulas in lists

Improve this answer
1
  • Hi Osama, does this answer help you to solve your problem? If yes, Please accept it as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily.
    – Ganesh Sanap - MVP
    Commented Mar 16, 2023 at 14:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.