I have three fields in a list called Level 1 data incident, Level 1 data incident(Yes), and Level 1 data incident(No).
Based on Yes or No selected from a drop down option only the appropriate field has to be entered which is a required mandatory to be entered, both options cannot be left empty. At least one has to be entered based on the Yes or No. Both of the options also cannot be left empty or I cannot save. Also I should not be able to save when I enter Level 1 data incident(No) field when I select Yes option or vice versa.
The code below works when I enter both the fields based on a Yes or No but doesn't work when both are empty or when I select Yes and the Level 1 data incident(No) or the opposite. Can you let me know where I might be doing wrong?
IF(OR(AND(ISBLANK([Level 1 data incident (No)])=TRUE,[Level 1 Data Incident]="No"),AND(NOT(ISBLANK([Level 1 data incident (No)]))=TRUE,NOT(ISBLANK([Level 1 data incident (Yes)]))=TRUE,[Level 1 Data Incident]="No")),FALSE,IF(OR(AND(ISBLANK([Level 1 data incident (Yes)])=TRUE,[Level 1 Data Incident]="Yes"),AND(NOT(ISBLANK([Level 1 data incident (Yes)]))=TRUE,NOT(ISBLANK([Level 1 data incident (No)]))=TRUE,[Level 1 Data Incident]="Yes")),FALSE,TRUE))