I have a custom SharePoint 2010 List that I am attempting to perform list verification on. I have searched Google, Microsoft, and Stack however I can't seem to wrap my head around how to perform the following verification to get it to resolve as TRUE or FALSE for all situations.
This is a multi-column list, but for this validation I only care about Column B and Column D.
Column B is a Choice with the following items: Item A Item B Item C Item D Item E Item F Item G Column D is a Choice with the following items: Item A Item B Item C Item D Item E
Here is what I am trying to achieve:
Things I have tried: IF(), OR(), AND() using a combination thereof including nesting IF() statements. Note: I am aware of PreSaveAction() however I would rather use List Validation.
IF( OR( [Column B]="Item C", [Column B]="Item D", [Column B]="Item E" ) ,IF( OR( NOT([Column D]="Item A"), NOT([Column D]="Item E") ) , TRUE , FALSE ) , FALSE )
In this example, If Column B is not Item C, Item D, or Item E the validation is FALSE and the user gets the message.
How can I perform this validation?