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
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you SO much, Andrée!
I'm in the US and that second formula worked perfectly.
Have a wonderful day.
Cheers,
Susan
-
Excellent!
Happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives