RGY Button Edit Needed
How do I edit this formula to turn button yellow when due date is 5 days away.
=IF([% Complete]@row = 1, "Green", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row = TODAY(), "Yellow", "Green")))
Thanks!!!
~ Carla
Best Answer
-
@hicksiechick The formula below should do it.
=IF([% Complete]@row = 1, "Green", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row <= TODAY() + 5, "Yellow", "Green")))
Isis Taylor
ποΈ Core App and Project Management Certified π
πPeer Connect, Mobilizer, and Early Adopter Program
Business Analyst Senior
Answers
-
@hicksiechick The formula below should do it.
=IF([% Complete]@row = 1, "Green", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row <= TODAY() + 5, "Yellow", "Green")))
Isis Taylor
ποΈ Core App and Project Management Certified π
πPeer Connect, Mobilizer, and Early Adopter Program
Business Analyst Senior
-
Yes this worked! Thank you!!!
Help Article Resources
Categories
Check out the Formula Handbook template!