RYG Formula Based on number

Hello Community;


I am having trouble writing a formula to monitor the status of a project using the RYG buttons; so far l have been able to make it work for the Red and Green button, but l need it to reflect the Yellow button as well:


Less than 10 days to MFB = Red

between 11 - 24 = Yellow

More than 25 days = Green


How can l approach this??


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!