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

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!