Hi, I am looking for a formula that will use drop down box to show RYGB
IF not started is selected from drop down the colour dot should change to Green
IF in progress is selected from drop down the colour dot should change to Yellow
IF Completed is selected from drop down the colour dot should change to Blue
IF delayed is selected from drop down the colour dot should change to Red
Answers
-
Try something like this...
=IF(Dropdown@row = "Not Started", "Green", IF(Dropdown@row = "In Progress", "Yellow", IF(Dropdown@row = "Completed", "Blue", IF(Dropdown@row = "Delayed", "Red"))))
-
Thanks Paul. I tried the formula; it did not work. However through other blogs i got the following formula and it worked
=IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Gray", IF(Status@row = "Completed", "Green", IF(Status@row = "Late", "Red"))))
-
When you say it did not work do you mean there was an error? If so, which error exactly? I do notice that your column name is different in your formula as well as the text requirement for the "Red" output ("Delayed" vs "Late"). Just trying to figure out where I went wrong whether it be a syntax issue or if maybe it was just those couple of differences.
-
UNPASSABLE
-
Ah. Ok. That may have been the difference in the column names then. Thanks for the feedback.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!