Overall health of a project
I have a sheet that tracks multiple projects. Each project has multiple tasks. Each task has a health column. I would like to create an "overall health" column that looks at the others and assigns the most critical health. In this case the most critical would be Red (overdue), followed by Yellow (warning), then Green (on track) and finally Blue (complete).
See examples below.
In this example, "In-person BF Health" is red so overall health would be red since that is the most critical issue to address.
Help Article Resources
Check out the Formula Handbook template!