5

I have a SharePoint 2013 list with 3 dropdowns of which 1 must be selected. It doesn't matter which is selected as long as one of them has data. I tried to do the Validation Settings:

=IF(AND(ISBLANK([Initial Pleadings])=TRUE,IF(AND(ISBLANK([Memos or Motions])=TRUE,IF(AND(ISBLANK([Other Filings]=TRUE))

but it doesn't seem to take. I want a message to pop up saying that the user must select a document type. I'm having a hard time getting it to work. Any help would be greatly appreciated.

8

Try this

   =OR(
       NOT(ISBLANK(FirstColumn))
       ,NOT(ISBLANK(SecondColumn))
       ,NOT(ISBLANK(ThirdColumn))
      )

You need OR rather than AND

More information about OR here and AND here

  • 1
    Note that OR itself returns a TRUE/FALSE so you can do without the IF statement – Danny '365CSI' Engelman May 23 '17 at 20:12
  • 1
    Perfect! That worked excellently! – Kimberly Abaid May 23 '17 at 20:54
  • 1
    @Kimberley, then mark his answer as the correct one.. that is how SO works. Note: Because SharePoint is loosly typed 0 is FALSE and any other number is TRUE; you could also do:NOT(ISBLANK(FirstColumn)+ISBLANK(SecondColumn)+ISBLANK(ThirdColumn)) – Danny '365CSI' Engelman May 24 '17 at 8:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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