Countifs Multi-select Contact

aclay

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!

 

Andrée Starå

Hi,

This probably helps: 

https://community.smartsheet.com/comment/153201#comment-153201

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

aclay

Thanks that helped.  I got what I needed to work.

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée