Skip to main content
1 of 3
T Zhang
  • 195
  • 3
  • 18

SharePoint 2013 calculated column adding multiple if statement

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?

T Zhang
  • 195
  • 3
  • 18