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)
Thanks! SharePoint does not like OR, at all. That's where the sticking point is. What do you recommend as a way forward? Two calculated columns referencing each function or is there a way to do all of this for one calculated column. I'd appreciate any guidance.
You can try this way:
=IF([Choice Type]="Choice Type 1","Optional",IF([Choice Type]="Choice Type 2","Optional",IF([Choice Type]="Choice Type 3","Optional","Not Optional")))
RG
Dimitrij