I have a List with multiple columns and want to do validation on 2 columns based on the value of a drop-down list and want to do validation on the list with the following conditions.
Column 1 ( Type ) if value ( others ) is selected then the field shouldn't be blank
Column 2 ( Location ) if value ( others ) is selected then the field shouldn't be blank
I am able to do only one condition at a time with this formula:
Can you advise what will be the formula that will have both conditions?