Metric Sheet Formula

Seatora

Hi All,

I'm trying to write a formula to achieve the following:

In the source sheet: Check if the "Resource Type" column contains "Analytic/Data". If it does, it counts the occurrences where the "Deadline Health" column contains the value of the current cell in the "Description" column, otherwise, it returns an empty string. Any Ideas why this is not working?

=IF(CONTAINS({Resource Type}, "Analytic/Data"), COUNTIFS({Deadline Health}, CONTAINS({Description@row}, @cell)), "")

Thanks in advance!

Ashley

JamesB

@Seatora

Use your countifs more directly.

=COUNTIFS({Resource Type},"Analytic/Data",{Deadline Health},Description@row)