Countifs Multi-select Contact

aclay
aclay ✭✭
edited 12/09/19 in Formulas and Functions

Hi Everyone,  I have a sheet that contains a list of projects.  In the sheet I have a column that is setup as a contact column and allows multiple contacts (Project Managers) and a column for project state (State).  In my statistic sheet I list all of my project managers(ITPMO ProjectManager) and I want to look back into the first sheet and count the number of projects each PM and total for each state.  I have tried the below but that only picks up the projects where they are the only contact in the column.

=COUNTIFS({Project Managers}, [ITPMO Project Managers]@row, {State}, "Scoping")

Help Please!

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!