RYG Ball Formlas

Lori Khoury
Lori Khoury ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am having a hard time putting together the formula for my Health Column- RYGB Ball.   I need the formula to be the following.  Any chance some one could help put this formula together for me?  Thanks

  1. If Status is Not Started then Health is Blank
  2. If Status is In Process and is equal to or past the Due Date then Health is Yellow
  3. If Status is In Process and before due date then Green
  4. If Status is Complete or Closed then Health is Blue


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!