Forum Discussion

Dimitrij_P's avatar
Dimitrij_P
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 = 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

 

Lists
SharePoint Online
  • RobElliott's avatar
    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)

  • AlexinEdmonton's avatar
    AlexinEdmonton
    Copper Contributor
    Jul 07, 2022

    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.

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    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)

    • Dimitrij_P's avatar
      Dimitrij_P
      Copper Contributor
      Sep 22, 2021
      Hi Rob,
      thank you for your quick reply!

      I've tried your solution, unfortunately, it doesn't help. Still get the syntax error.

      Dimitrij
      • RobElliott's avatar
        RobElliott
        Silver Contributor
        Sep 22, 2021

        It works perfectly for me, so what is the formula you have used?

    • tomas_12's avatar
      tomas_12
      Copper Contributor
      Sep 13, 2023

      RobElliott 

       

      Hello there, could you please give me a help hand here?

      I dont know where is the issue, its little more complikcated formula..

       

      Its all about one collumn, basically there are few conditions

      If the number in collumn 1 is > 6950000 then in new calculated collumn should be 40% and etc.

       

      =IF([collumn1]<6950000,"0%",
        IF(AND([collumn1]>=6950000,[collumn1]<7050000),"40%",
          IF(AND([collumn1]>=7050000,[collumn1]<7150000),"50%",
            IF(AND([collumn1]>=7150000, [collumn1]<7200000),"60%",
              IF(AND([collumn1]>=7200000, [collumn1]<7250000),"70%",
                IF(AND([collumn1]>=7250000, [collumn1]<7350000),"80%",
                  IF(AND([collumn1]>=7350000, [collumn1]<7500000),"90%",
                    IF([collumn1]>=7500000,"100%",
                    )
                  )
                )
              )
            )
          )
        )
      )

       

      • UA-HandCrafts's avatar
        UA-HandCrafts
        Copper Contributor
        Sep 13, 2023

        tomas_12 

        Hi, try this

        =IF([column1]<6950000, "0%", IF(AND([column1]>=6950000,[column1]<7050000), "40%", IF(AND([column1]>=7050000,[column1]<7150000), "50%", IF(AND([column1]>=7150000,[column1]<7200000), "60%", IF(AND([column1]>=7200000,[column1]<7250000), "70%", IF(AND([column1]>=7250000,[column1]<7350000), "80%", IF(AND([column1]>=7350000,[column1]<7500000), "90%", IF([column1]>=7500000, "100%")))))))))

  • valderes-squadra's avatar
    valderes-squadra
    Copper Contributor
    May 13, 2022
    Hi all.

    I've the same problem. I tried replacing ; by , I tried with another browsers. 😞

Resources