SharePoint List Validation Settings Formula with Nested IFs

Question

I'm trying to turn this logic into a formula that can be used in the Validation Settings, but I don't know the right syntax.

=IF([Event Type]="Option 1",IF(ISBLANK([Option 2]),FALSE,TRUE),TRUE)

Answer 1

Hi @Michael T. Sherman，

You will need to add AND when you have two condition. The formula should be like following

=IF(AND([Event/Project Type]!="A3 Problem Solving",[Event/Project Type]!="Just Do It"),IF(ISBLANK([Report Outs]),FALSE,TRUE),TRUE)

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.