What is the formula for RYGB to use for status i.e. Green for Complete, Red for At Risk,etc.,

lupe.neukirch68876

I appreciate the help on this.  This is the formula that I am using:

=IF([Status]4=At Risk, "Red", IF([Status]4=Not Started, "Yellow", IF([Status]4= Complete,”Green”, IF([Status]4= In Progress "Blue",””))))

Andrée Starå

Hi Lupe,

It looks like you created the formula outside of Smartsheet so some characters are wrong.

Try something like this.

=IF(Status@row = "At Risk"; "Red"; IF(Status@row = "Not Started"; "Yellow"; IF(Status@row = "Complete"; "Green"; IF(Status@row = "In Progress"; "Blue"; ""))))

The same version but with the below changes for your and others convenience.

=IF(Status@row = "At Risk", "Red", IF(Status@row = "Not Started", "Yellow", IF(Status@row = "Complete", "Green", IF(Status@row = "In Progress", "Blue", ""))))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

lupe.neukirch68876

Andree- Thank you, thank you, thank you!  The second formula worked like a charm :)  This is most helpful

Andrée Starå

Hi Lupe,

It looks like you created the formula outside of Smartsheet so some characters are wrong.

Try something like this.

=IF(Status@row = "At Risk"; "Red"; IF(Status@row = "Not Started"; "Yellow"; IF(Status@row = "Complete"; "Green"; IF(Status@row = "In Progress"; "Blue"; ""))))

The same version but with the below changes for your and others convenience.

=IF(Status@row = "At Risk", "Red", IF(Status@row = "Not Started", "Yellow", IF(Status@row = "Complete", "Green", IF(Status@row = "In Progress", "Blue", ""))))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

lupe.neukirch68876

Andree- Thank you, thank you, thank you!  The second formula worked like a charm :)  This is most helpful

Andrée Starå

Excellent!

You're more than welcome!

I'm always happy to help!