SOLVED

Sharepoint list, Calculated Column, IF syntax error

%3CLINGO-SUB%20id%3D%22lingo-sub-2774174%22%20slang%3D%22de-DE%22%3ESharepoint%20list%2C%20Calculated%20Column%2C%20IF%20syntax%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2774174%22%20slang%3D%22de-DE%22%3E%3CP%3EHi%20all%2C%20%3CBR%20%2F%3E%20I%20have%20the%20following%20problem%3A%20I%20have%20a%20%3CBR%20%2F%3E%20SharePoint%20list%20with%20different%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%201%20%3D%20single%20choice%20column%20with%20drop-down%20and%20values%201%2C%202%2C%203%3C%2FP%3E%3CP%3ENow%20I%20want%20to%20create%20a%20Column%202%20%3D%20calculated%20column%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formula%20looks%20like%20this%20%3CBR%20%2F%3E%20%3DIF(%5BColumn%201%5D%20%3D%203%3B%20%22OK%22%3B%20%22NOK%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20the%20confirmation%2C%20I%20get%20a%20message%20of%20a%20syntax%20error.%3CBR%20%2F%3EI%20don't%20know%20where%20the%20error%20should%20be%2C%20since%20the%20formula%20is%20quite%20simple.%3C%2FP%3E%3CP%3EDo%20you%20have%20a%20hint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%2C%3C%2FP%3E%3CP%3Ebest%20regards%3C%2FP%3E%3CP%3EDimitrij%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2774174%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2774293%22%20slang%3D%22de-DE%22%3ERe%3A%20Sharepoint%20list%2C%20Calculated%20Column%2C%20IF%20syntax%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2774293%22%20slang%3D%22de-DE%22%3EHi%20Rob%2C%20%3CBR%20%2F%3E%20thank%20you%20for%20your%20quick%20reply!%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20tried%20your%20solution%2C%20unfortunately%2C%20it%20doesn't%20help.%20Still%20get%20the%20syntax%20error.%3CBR%20%2F%3E%3CBR%20%2F%3EDimitrij%3C%2FLINGO-BODY%3E
Occasional Contributor

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

 

6 Replies
best response confirmed by Dimitrij_P (Occasional Contributor)
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)

Hi Rob,
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:

calcChoiceColumn.png

 

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

@RobElliott 

now it works - very strange - I've not changed anything.

 

However, it works - so thank you very much for your suppot!

 

Best Regards

Dimitrij