COUNTIF and CONTAINS function

Looking for help as to why the below formula isnt working:

=COUNTIFS({Intake - Project Customer Satisfaction Sur Range 7}, "Professional Services", {Intake - Project Customer Satisfaction Sur Range 6}, CONTAINS([Primary Column]@row, @cell))

Let me know if you need any additional info.

Thanks

Find more posts tagged with

Accepted answers

All comments

SteyJ

https://community.smartsheet.com/discussion/113250/countif-and-contains-function

Hello @Angela Logie

What error are you getting when trying to use this formula?

Angela Logie

Actually no error, just "0" but that's incorrect

Paul McGuinness

Hi @Angela Logie

Normally when a cross sheet formula isn't doing as expected especially something as straightforward as yours I would check that the ranges are correctly assigned.

So i would check that the two ranges:

{Intake - Project Customer Satisfaction Sur Range 7}

{Intake - Project Customer Satisfaction Sur Range 6}

are highlighted / selected correctly as sometimes when selecting ranges cross sheet the selection doesn't lock in correctly.

If that's not the issue, I would then check that the criteria are correct and the columns are correctly formatted.

Hope that helps

Thanks

Paul

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.