LZ_MSFT
2020-02-06 15:57
Use the formula below to achieve it.
=IF([column1]="xxx",IF(LEN([column2])>0,TRUE,FALSE),TRUE)
I have a problem with the column validation in a sharepoint-list. I want to force the user to fill column2 if a certain value is chosen in column1 (dropdown). Otherwise it coulmn2 should be left blank. So far I tried:
= IF([column1]="xxx";LEN([column2]>0;LEN([column2]=0))any help is much appreciated. Thanks in advance!
Use the formula below to achieve it.
=IF([column1]="xxx",IF(LEN([column2])>0,TRUE,FALSE),TRUE)