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)
Hello all just wanted to throw in my comments that I think sometimes the formula required a semicolon and sometimes it requires a comma, based on the default language of your environment. In my case the default environment was French and requires a semicolon. I believe other sites have other default languages, so their formulas required commas. This is really painful to troubleshoot and documentation seems pretty lacking in this regard from what I can tell.
- Thank you!! It was exactly this that caused my error. Very similar requirement: going from an enum value to display names. Belgian user, Dutch SPO site, ";" needed instead of ",".
- AlexinEdmonton Thank you problem solved 😄
