RYGB formula linking to Status Drop-Down List

Susan@SMC

Hi SmartSheet Experts,

I'm trying to automate RYGB status ball colors to link to the following options from a "Status" column drop-down list, as follows:

Green = In Progress

Yellow = Potential Delay

Red = Behind Schedule

Blue = Complete

Here's the formula I've come up with, but it's giving me an "#Unparseable" error.

=IF(Status3, ="In Progress", "Green"), IF(Status3, ="Potential Delay", "Yellow"), IF(Status3, ="Behind Schedule", "Red"), IF(Status3, ="Complete", "Blue")

Can you tell me what I'm doing wrong?

Kind Regards,

Susan

Andrée Starå

Hi Susan,

Try this.

=IF(Status@row = "In Progress"; "Green"; IF(Status@row = "Potential Delay"; "Yellow"; IF(Status@row = "Behind Schedule"; "Red"; IF(Status@row = "Complete"; "Blue"))))    

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

=IF(Status@row = "In Progress", "Green", IF(Status@row = "Potential Delay", "Yellow", IF(Status@row = "Behind Schedule", "Red", IF(Status@row = "Complete", "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?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Susan@SMC

Thank you SO much, Andrée!

I'm in the US and that second formula worked perfectly.

Have a wonderful day.

Cheers,

Susan

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée

Mike Wilday

Hi Susan, when you a nest an IF statement, you don't want to close the statement by adding an ending parenthesis until the very end of the formula. So in your instance, as Andree corrected, you would do... 

IF(THIS, THEN THIS, IF(This, Then this, IF(This, then This)))

Each of the if statements are opened in the the ELSE portion of the IF statement and nested within each other. They are all finally closed at the end.

Hope that helps bring understanding to the solution.