RYG Health formula based on due date and % complete

Options

I'm trying to create a formula to calculate the below:

'Due date' is in the next 10 days and '% complete' is less than 50% = "Red"

'Due date' is in the next 10 days and '% complete' is less than 90% = "Yellow"

'Due date' is in the next 10 days and '% complete' is greater than 90% or 100% = "Green"

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!