Sep 22 2021 06:59 AM
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
Sep 22 2021 07:08 AM
Solution@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)
Sep 22 2021 07:18 AM
Sep 22 2021 07:18 AM - edited Sep 22 2021 07:21 AM
It works perfectly for me, so what is the formula you have used?
Sep 22 2021 07:20 AM
Sep 22 2021 07:26 AM
@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)
Sep 22 2021 08:44 AM
now it works - very strange - I've not changed anything.
However, it works - so thank you very much for your suppot!
Best Regards
Dimitrij
May 13 2022 11:34 AM
Jul 06 2022 06:19 PM
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.
Jul 21 2022 08:54 AM
Aug 29 2022 05:37 AM