SharePoint 2013 calculated column adding multiple if statement

Question

i created a calculated column(column name"status") with a simple formula below:

=if([Priority]="Low"), "Yellow", if([Priority]="Normal"),"Green", if([Priority]="High", ”Red")))

As you can see, what I want to achieve is that, when the "Priority" column = "Low", then the "status" column = "Yellow", and when it is ="Normal", the "status" column = "Green". The formula looks to me is correct, but when i was trying to save the page, i always got an error message with the following message:

"Sorry, something went wrong The formula contains a syntax error or is not supported."

Can you please help?

Answer 1

It helps when your write your Formula in a text editor (even Notepad will do) and add line-breaks and indents

=if([Priority]="Low")
 , "Yellow"
 , if([Priority]="Normal")
 , "Green"
 , if([Priority]="High", ”Red")
))

Where it should be

=if([Priority]="Low"
    , "Yellow"
    , if([Priority]="Normal"
         , "Green"
         , if([Priority]="High"
              , ”Red"
             )
        )
   )

On copy/paste to SP all whitespace will be removed (so retain that original Notepad file!)

Note: In a decent IDE this will also catch your wrong double-quote..

Answer 2

There were two problems with your formula.

The first one that you missed to change the character left to "Red" to a quotation mark. The difference is tiny, but it is there. ”Red"

Second problem were that you were closing each condition, rendering the last closing brackets useless.

=if([Priority]="Low", "Yellow", if([Priority]="Normal","Green", if([Priority]="High", "Red")))