IF Function Due Date
I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days with the due date, I would like it remain yellow until a date is entered in the completed column, then I would like it to automatically change to gray.
However if a date is not entered in the completed column and the due date is past 120 days and is 90 days until the due date then I want it to change from yellow to red, and remain red until a date is entered in the completed column, then once the date is entered in the completed column I want it to change to gray.
If the due date column is not within the 120 or 90 days to due date I would like it be green and stay green until the due date becomes 120 days till due date or 90 days till date, or until a date is entered in the completed date column then change to gray.
Can some one help with this?
Help Article Resources
Check out the Formula Handbook template!