IF(OR with RYGG
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.
Grey = Not started
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.
Help Article Resources
Check out the Formula Handbook template!