Automating RGY balls
I am trying to automate the Red, Green, Yellow balls in my project plan but I can't seem to make the formula work. I want this to be based on 2 criteria, one being % complete and the other one on the end date. So I've tried something like =IF([% Complete]1 < 1, IF(TODAY(3 / 5 / 2019) - [End Date]1 > 0, "Red")) and I still have to add in this formula the options for yellow and green but I can't seem to make this work let alone a longer syntax. I realize that having this automated for what's already 100% and having a blue ball might be way too much since I'm a beginner but I'd like to figure out the RGY balls at least. So any help is appreciated!
Help Article Resources
Check out the Formula Handbook template!