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"
Best Answer

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

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

@Teri Stabler Thank you! It worked!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!