Forum Discussion
Solved
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)
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.
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 😕