RYG status set by % Complete and End Date

Options

I am using a Smartsheet template (Project Tracking Template) and it comes with RYGB statuses. I would like to only use RYG and adjust the formula but am failing miserably. Please help!!!

Here's what I'm trying to accomplish:

  • Green = If % complete is 100% or if end date is greater than today 
  • Yellow = If % complete is not 100% and the end date is within the next 7 days (in the future)
  • Red = If % complete is not 100% and the end date has passed 

Any help would be appreciated!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!