I am trying to write a formula that will count if a specific word is mentioned in a formula.

=COUNTIF([Queue Name]:[Queue Name], "*INBOUND*")

It returns zero with or without the "*" in the quotes. I know this works in Excel, but not sure how to make it work in smart sheets. The column will have words in front of or behind the word I am looking to count, INBOUND.

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @NCH

The CONTAINS function looks to see if a text string appears anywhere within a cell, effectively as if there were wild cards around the string.

=COUNTIFS([Queue Name]:[Queue Name], CONTAINS("INBOUND", @cell))

Does this work for you?

Kelly

All comments

Kelly Moore

Hey @NCH

The CONTAINS function looks to see if a text string appears anywhere within a cell, effectively as if there were wild cards around the string.

=COUNTIFS([Queue Name]:[Queue Name], CONTAINS("INBOUND", @cell))

Does this work for you?

Kelly

NCH

That worked. Thank you very much.

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.