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 = calculated column
The formula looks like this
=IF([Column 1] = 3; "OK"; "NOK")
After the confirmation, I get a message of a syntax error.
I don't know where the error should be, since the formula is quite simple.
Do you have a hint?
Thank you in advance,
best regards
Dimitrij
23 Replies
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.
- AlexinEdmonton Thank you problem solved 😄
- 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 ",".
- Hi all.
I've the same problem. I tried replacing ; by , I tried with another browsers. 😞
