COUNTIFS and HAS formula

shannon_bankpmo

I'm having a problem with one of our widgets on a dashboard that tracks how many projects a user is a team member of. It is currently showing all projects the team member is assigned to, regardless of project status (we only want to show the in progress ones). I have come up with the formula below that references our Master Project List; however, it is not working. Please help.

=COUNTIFS({Project Status}, "In-Progress" AND({Project TM}, HAS(@cell, [Team Member ]@row)))

Nic Larsen

Try:

=COUNTIFS({Project Status}, "In-Progress", {Project TM}, HAS(@cell, [Team Member ]@row)

shannon_bankpmo

Thanks, Nic. I used the formula below to get the needed info, which is basically the same as your suggestion. I appreciate your help!

=COUNTIFS({Project TM}, HAS(@cell, [Team Member]@row), {Project Status}, "In-Progress")