I have a SharePoint 2010 list with Drop Down column named "A" which has 3 choice values.
The list has 3 more columns namely "B","C" and "D".
I'm trying to set a validation on the list as below:
When choice 1 is selected in Column "A",columns "B","C" and "D" can be blank.
When choice 2 is selected in Column "A",column "B" should be made mandatory.
When choice 3 is selected in Column "A",columns "C" and "D" should be made mandatory.
I'm not able to make my formula work for more than 1 choice.Below is the formula I have:
=IF([A]="Choice 1",IF(OR([B],[C],[D]="",TRUE,FALSE),TRUE))