Hi, I am looking for a formula that will use drop down box to show RYGB

Sean Turner

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

Paul Newcome

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"))))

Sean Turner

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"))))

Paul Newcome

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.

Sean Turner

UNPASSABLE

Paul Newcome

Ah. Ok. That may have been the difference in the column names then. Thanks for the feedback.