Project Manager Count

JEastep

Hello -

I'm trying to build out a dashboard where I include a chart containing the project manager and the count of projects they currently have utilizing the PMO workspace. With some of our projects being large, we've allowed for multiple PMs to be on 1 project. Is there a way to modify the COUNTIFS to account for a name appearing in a cell containing another PM?

Genevieve P.

Hi @JEastep

Yes! 🙂

You can use the HAS Function to see if a muti-select range has that one contact along with other contacts in a cell.

For example:

=COUNTIFS({Contact Column}, HAS(@cell, [Contact Reference]@row))

Cheers,

Genevieve

Genevieve P.

Hi @JEastep

Yes! 🙂

You can use the HAS Function to see if a muti-select range has that one contact along with other contacts in a cell.

For example:

=COUNTIFS({Contact Column}, HAS(@cell, [Contact Reference]@row))

Cheers,

Genevieve

JEastep

Hi @Genevieve P.

This is brilliant! Thank you for solving my problem and introducing me to the HAS function!!

Thanks!

Genevieve P.

Glad this helped! 🙂