Traffic light system by using data from drop down list in anther column

Susanna Ferry

Hi All

I am trying to have an automated traffic light system dependant on the option chosen from my 'Status' column, I would like it to automatically choose the correct colour in the 'RAG Status' column, so Red for not started, Yellow in progress, Green for completed & grey for On Hold, this has really stumped me !

jmyzk_cloudsmart_jp

Hi @Susanna Ferry

Please try this.

=IF(Status@row = "Not Started", "Red", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Complete", "Green", IF(Status@row = "On Hold", "Gray"))))

https://app.smartsheet.com/b/publish?EQBCT=52a2693f666646f2824d6664164957fa

jmyzk_cloudsmart_jp

Hi @Susanna Ferry

Please try this.

=IF(Status@row = "Not Started", "Red", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Complete", "Green", IF(Status@row = "On Hold", "Gray"))))

https://app.smartsheet.com/b/publish?EQBCT=52a2693f666646f2824d6664164957fa

Susanna Ferry

Thank you so much, that works perfectly, unfortunately formulas are not really my forte

jmyzk_cloudsmart_jp

@Susanna Ferry

Happy to help!😁