Forum Discussion
Solved
Sharepoint list, Calculated Column, IF syntax error
Hi all, I have the following problem: I have a SharePoint list with different columns. Column 1 = single choice column with drop-down and values 1, 2, 3 Now I want to create a Column 2 = calcu...
Dimitrij_P it needs to be =if([Column 1]="3","OK","NOK")
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
The same you've posted:
=if([Column 1]="3","OK","NOK")
=if([Column 1]="3","OK","NOK")
Dimitrij_P are you sure? This is my list and the formula which gives exactly what you wanted:
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
now it works - very strange - I've not changed anything.
However, it works - so thank you very much for your suppot!
Best Regards
Dimitrij