Forum Discussion

Copper Contributor

Sep 22, 2021

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...

Lists

SharePoint Online

RobElliott
Sep 22, 2021
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)

tomas_12

Copper Contributor

ganeshsanap
Hello,

sadly I tried your formula with right collumn name, but didnt work 😕

About using ";" instead of "," - not sure if this is the case, other callculated collumns are with "," too.

"Sorry, something went wrong

The formula contains a syntax error or is not supported"

But thanks for your help, if you have anything else in mind, I will be greatful

ganeshsanap

MVP

Sep 14, 2023

tomas_12 What is the column/data type of your column 1?

Also, make sure you are returning the calculated column as single line of text here:

Please consider giving a Like if my post helped you in any way.

tomas_12
Copper Contributor
Sep 14, 2023
ganeshsanap
Collumn 1 is a calculated collumn, that adds up 3 different numbers together
collumn1 = collumnA+collumnB+collumnC (all numbers)
and its Currency format

2nd - Made sure that i want value to return as single line text, but didnt work too 😕