0

I know how I can make the conditional formatting based on one selection, but I have an issue with multiple selections.

I have a City dropdown column with three options: Test, Test1, Test3. My other column is FirstName. If users select either Test or Test 1, the FirstName column should be mandatory.

The below formula works with only one selection:

=IF([City]="Test",IF(ISBLANK([FirstName]),FALSE,TRUE),TRUE)
Improve this question
1

1 Answer 1

Reset to default
1

This is a known limitation of SharePoint.

You cannot use multiple selection choice column in list validation or calculated column formulas.

Improve this answer
2
  • Hi Harris, does this answer help you in any way? If yes, Please Upvote(^) and accept as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily.
    – Ganesh Sanap - Microsoft MVP
    Apr 5, 2022 at 14:06
  • Hi @Harris, does this answer help you in any way? If yes, Please Upvote(^) and accept as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily. It also removes this question from "Unanswered questions" list.
    – Ganesh Sanap - Microsoft MVP
    Aug 10, 2022 at 5:32

Your Answer

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

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