Formula Help

System

This discussion was created from comments split from: COUNT COLLECT.

Trevor S.

COUNT.jpg

Hoping this community could help me out.

Using the Project Management Office template out of the box (portfolio metrics sheet to be exact) - however for 'In Progress' project status' we have added a few more - "Blocked" and "In Closing." I'm trying to get the standard formulas for the RAG status' to update accordingly but I'm missing something; I keep receiving #UNPARSEABLE.

The formula for Green, initially, only accounts for "In Progress." I would like it to also consider the above 2 ("Blocked" and "In Closing").

Thank you to all in advance. Much appreciated!

Update - is this accurate:

Paul Newcome

Try this:

=COUNTIFS({Project Status}, OR(@cell = "In Progress", @cell = "In Closing", @cell = "Blocked"), {Project Category}, @cell = High$1, {Schedule Health}, @cell = $Label@row)