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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!