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)
It works perfectly for me, so what is the formula you have used?
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