I have a multichoice dropdown that has the response of Yes or No. If the response is set to yes, then I need it to make other fields required. After doing some research, I found a way blog that explains how to make a single field required if it is set to yes.

The problem is, I need multiple and after a few hours of research and trying this or that, I am unable to figure it out. Below is what I have for one field. Can someone show me how to do it for multiple?



2 Answers 2


Use the AND() function with the code snippet that's been provided.


  • I tried this and I get this error "The formula cannot refer to another column.". I am assuming you mean go into the settings for each column and add that line to the Column Validation? Oct 4, 2016 at 21:19
  • Ah, I was mentally going through the process and didn't test it; I was thinking of the wrong area. You could try using the AND() function. AND(<if for field1>,<if for field2>, etc.). This link says it only applies to 2007 and earlier, but I know it works in 2010 as well, so I would guess it works in 2013. Oct 5, 2016 at 11:53
  • I actually got it after a while longer, just now got a chance to test it out. After I realized Excel uses the same type of functions, I looked it up that way and found my answer. Will post an answer, but it looks like your way may be a little cleaner so I am curious what you come up with. Oct 5, 2016 at 12:25
  • I updated my answer with an example Oct 5, 2016 at 12:50

After realizing that SharePoint uses about the same type of functions as Excel, I went at it that method and was able to use Excel for much easier testing. Here is my solution:


I learned that you can nest this all the way up to 64 IF statements.

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.