COUNTIF Formula Only Works on Certain Rows

Hey Smartsheet Community, I am currently being stumped by this formula that for some reason only works in a few rows.

It is a COUNTIF formula that is counting the number of assignments each person has. I will paste it below:

=COUNTIFS({Resource Name}, FIND([Qarbon Owner]@row, @cell) > 0)

I have 29 people that I need to count their number of tasks assigned, and it only works on 2 of the rows for some reason.

Some more info on this, these were running fine until recently a coworker changed some of the data in the sheet and that's when it stopped working.

Any help here is much appreciated.

Thank you

Find more posts tagged with

Formulas

Accepted answers

All comments

Mark Cronk

Try:

=COUNTIFS({Resource Name}, CONTAINS([Qarbon Owner]@row, @cell))

Mark

Paul Newcome

If you are using a contact type column, the CONTAINS function will not work. What changes did the other person make?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.