Forum Discussion
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)
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)
Hi Rob,
thank you for your quick reply!
I've tried your solution, unfortunately, it doesn't help. Still get the syntax error.
Dimitrij
thank you for your quick reply!
I've tried your solution, unfortunately, it doesn't help. Still get the syntax error.
Dimitrij
It works perfectly for me, so what is the formula you have used?
- The same you've posted:
=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)
