Metrics Formula

sanchezf

I am trying to find out how to do a formula that looks at the project manager and the various project statuses for each of their assigned projects. Ex. John Doe has 2 projects "in progress", 3 "completed"; 1 "not started"

Teri Stabler

Here's how I'd get to those metrics: =COUNTIFS([Project Manager]:[Project Manager], "John Doe", Status:Status, "in progress").

Teri Stabler

Here's how I'd get to those metrics: =COUNTIFS([Project Manager]:[Project Manager], "John Doe", Status:Status, "in progress").

sanchezf

@Teri Stabler Thank you! It worked!