Automating RGY balls

Options
jona28
jona28 ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello,

 

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! 

Thank you!

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!