Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions