RYGG Ball

Blessing
Blessing ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello 

I have looked through the list of current Formula but cant find any that matches what I am trying to do (see below): 

If task due date is > 2 days from current date (today) AND Status is NOT STARTED or IN PROGRESS then flag the Green ball 

If a task due date is < 2 days from current date (today)AND Status is NOT STARTED or IN PROGRESS then flag the Yellow ball 

If a task due date is today AND AND Status is NOT STARTED or IN PROGRESS then flag the Red ball

If a task status is COMPLETE then flag the Gray ball

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!