Hello,
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 a 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:
=IF([Type]="Others",IF([Other Type]="",FALSE,TRUE),TRUE)
Can you advise what will be the formula that will have both conditions?
Thank you in advance
