Count Task Status across Sheets
For each of our sheets, we use a "Health Status" of Red, Yellow, Green to indicate how that task is going. I would like to create a report which looks across all sheets and simply counts up the total number of tasks which are Red or Yellow. I can easily create the report which shows the list of individual tasks which are Red or Yellow but I cannot figure out how to "sum" this up.
My ultimate goal is to create a Dashboard Chart which will simply show this summed up number in a pie or bar chart but I need to get the report working first before I can make a chart out of it.
Help Article Resources
Check out the Formula Handbook template!