I would like to automate a RYGG column, assuming that my team is entering there own start and finish dates but due dates will be created by senior staff.
Yellow=In progress
Red=Overdue
Grey = Not started
Green=Completed
So IF start date is before due date, Yellow or if Finish date is before due date Green, etc. An assignment can be started late and finished on time but we want to track task weekly through reports.
=IF(OR([Start]7<[Due Date]7, ([Finish]7<=[Due Date]7, "Yellow", “Green”, IF(OR([Start]7>[Due Date]7, ([Finish]7<=[Due Date]7,"Red", “Green”, IF(OR(ISBLANK([Start]7), IF([Finish]7<=[Due Date]7, “Gray”, "Green"))))
I've tried a few different formulas.
Thank you,