Trying to get a count of status for specific team members

I am trying to find out how many initiatives with a specific status have certain team members in the Project Team column. For example, how many initiatives is Leo on the team where the status is Not Started? I have tried the following:

=COUNTIFS({EITPort_Status_24}, "Not Started", FIND("Leo Liao", @cell, >0)) - Gives me an Invalid Operation error

=COUNTIFS({EITPort_Status_24}, "Not Started", HAS(@cell, "Leo Liao")) - Gives me an Incorrect Argument error

Any thoughts on how to make this work?

Find more posts tagged with

Accepted answers

All comments

Mark.poole

@Alisa Buck How large is the reference you are using is it covering all the columns required?

Also. COUNTIFS() function works like this.

=COUNTIFS(Range,Criteria, Range, Criteria,Range, Criteria)

you have to give a range to look before every criteria to pull the information.

Paul Newcome

You are close with both.

=COUNTIFS({EITPort_Status_24}, "Not Started", {Source Sheet Contact Column}, FIND("Leo Liao", @cell) >0)

=COUNTIFS({EITPort_Status_24}, "Not Started", {Source Sheet Contact Column}, HAS(@cell, "Leo Liao"))

Alisa Buck

Thanks all! I got it to work using…

=COUNTIFS({EITPort_Team_24}, FIND("Leo Liao", @cell) > 0, {EITPort_Status_24}, FIND("Not Started", @cell) > 0)

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.