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