Add one more condition to check project status

Joseph Aloysias

Hi @Paul Newcome I'm able to calculate projects falls under on time and delay for the month, I would like to check "project status" column and check for "completed",

=COUNTIFS({Month}, Label@row, {OTIF}, [Category 1]$4) im using this formula currently,

Paul Newcome

You would add another range/criteria set following the same syntax.

Joseph Aloysias

Thank you @Paul Newcome I got it.

Is there a way we can hide 'Zeros' in the dashboard? would like to show only values.