RYG Status Balls Formula Help!!
I am looking for help developing a formula for the following RYG Status Balls Conditions:
- If status is "not started", grey
- If it is 1 day before "due date" and status is NOT "complete", yellow
- If it is the day of the "due date" or past "due date", red
- If status is "complete", or "in progress" and it is 2 days or more away from "due date", green
Can someone help me?! I am pretty novice with formulas and am having issues editing some of the ones I found on the forums to reflect my specific conditions. Any help would be amazing. 🙏
Help Article Resources
Check out the Formula Handbook template!