Nested If And Not Formula
I'm working to write a formula that displays a health ball (R,Y,G,B) that's based on a variety of logical expressions.
Below is what I am aiming to achieve.
Status@row = Complete, then Green
Status@row = On Hold, then Blue
Finish@row = Blank, then Blank
Here is where it gets tricky...
If Finish is less than today and status is NOT equal to Complete, then Red
If status = In Progress, and finish is equal to Today or two days previous (in other words, 2 or fewer days overdue), then Yellow
If status = In Progress and finish is three days previous or more (in other words, 3 or more days overdue), then Red
I'm getting caught up somewhere on the proper order of things. Any help would be appreciated!
Help Article Resources
Check out the Formula Handbook template!