Counting number of employees with tasks assigned to them

Hi all,

I was wondering if it's possible to count number of employees with tasks assigned to them?

The Responsible column is a contact list, is this OK when making a formula in the sheet summary section?

I want to be able to do something like:

COUNTIF([Responsible]:[Responsible], MG) Get the total and the further count how many task MG has due in one week or how many tasks he has overdue.

Is this possible?

Find more posts tagged with

Accepted answers

All comments

sedin hasanovic

I tried to do something like: =COUNTIF([Responsible]:[Responsible], AM) but that still does not work coming up as #UNPARSEABLE.

Sameer Karkhanis

If your column is a defined as single contact per cell then you can use,

=COUNTIF([Responsible]:[Responsible], "AM")

If your column can have multiple contact values per cell then use,

=COUNTIF([Responsible]:[Responsible], HAS(@cell, "AM"))

sedin hasanovic

Hey Sameer, it simply just comes up with #invalid column value doing either of those formulas when trying to apply them. Do I have to use the email value?

Andrée Starå

Hi @sedin hasanovic

I hope you're well and safe!

Try something like this.

=COUNTIF(Responsible:Responsible, "AM")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

sedin hasanovic

I've tried that combination. It looks like there might be something wrong with the sheet, because when I try the formula in another sheet see below:

Could there be a setting or something in the other sheet stopping me from making this formula work?

Andrée Starå

@sedin hasanovic

Strange!

Can you paste the formula you used in the other sheet that works?

sedin hasanovic

@Andrée Starå Hey mate, i think it might be something to do with the limitation Smartsheet has. I've got over 250 rows, so i'm guessing that might be the issue?

Cheers,

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.