Task Health - Red, Yellow, Green

blmccue ✭✭
edited 08/15/23 in Formulas and Functions

I am currently using =IF(TODAY() - [Due Date]@row < 0, "Green", IF(TODAY() > [Due Date]@row, "Red", IF(TODAY() - [Due Date]@row < [Processing Goal]@row, "Yellow"))) because I can't figure out how to get the yellow to work correctly.

I am looking for a formula that will display green if today is less than the due date, red if today is greater than the due date and yellow if today + 1/2 the processing goal is less than the due date. If the processing goal is 10 days, I want the health to turn yellow when we are 5 days from the due date so we can assign additional resources before we reach the due date. Can anyone help?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!