Formula for summarized health indicators for discrete categories
Perhaps this has been answered elsewhere - in which case I appreciate being redirected.
I am trying to determine if it is possible to create formulae that summarizes a health indicator symbol (Red, Yellow, Green) across multiple rows in a sheet, when further categorized by a variable in another column. So, in other words, I am trying to get a aggregate health symbol across each row/task in a given project, by task type category. This variable is "Task Type" (which includes 4 items: Training, Evaluation, Marketing, and Leadership).
Is this feasible and, if so, what recommendations would you have for parsing out the formula?
Happy to provide further information in case this is coming across garbled.
Help Article Resources
Check out the Formula Handbook template!