No matter which syntax i use, sharepoint throws me a syntax error on IF function.
here is what i have tried so far
= IF ( [colA] = "dddd"; "yes" ; "no" )
= IF ( [nr1] < [nr2]; "yes"; "no")
= IF ( [colA] = "ddd", "yes", "no") -my localization should use " ; "
= IF ( [colA] ='ddd'; 'yes'; 'no')
I can't figure out what's wrong, can this be something that is restricted from Sharepoint Admin in the enviroment?
Column1
. Try using this:=IF([Column1]="ABC";"OK";"Not OK")
. Also, return the data type of your column as "Single line of text".