Welcome!

RYGB formula linking to Status Drop-Down List

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

Find more posts tagged with

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

How can I view the Gantt chart in days?
When I use the zoom-in option, I can only see the day names but not the specific day numbers. I need my team to be able to see the exact dates for the tasks I have scheduled.
How to create stack column graph bars
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Not enough space in the cell for my notes
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…