COUNTIFS and HAS formula

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)))

Find more posts tagged with

Accepted answers

All comments

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")

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.