Skip to main content
SharePoint

Return to Question

formatted the question and updated the Tags
Source Link
moe
moe
  • 5.3k
  • 21
  • 34

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")))

asAs you can see, what iI want to achieve is that, when the "Priority""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."

canCan you please help?

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?

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?

formatted the question and updated the Tags
Source Link
edit approved Jun 20, 2017 at 4:49
TARUN
edit approved Jun 20, 2017 at 4:49
TARUN
  • 2.9k
  • 20
  • 45

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")))

=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""Priority" column = "Low", then the "status" column = "Yellow""status" column = "Yellow", and when it is ="Normal", the "status" column = "Green"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." canmessage:

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

can you please help?

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?

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?

Source Link
T Zhang
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?