Wildcard workaround

Hi,

Trying to get some counts for a report and have run into a bit of a road block. In excel, I would typical use a count formula and a wildcard. However, Smartsheet doesnt seem to have the capability. Below if my code:

=COUNTIFS({Papers Range 2}, "*O'Malley*", {Papers Range 3}, "1 - Published")

How would I edit this to correctly capture the count? Thanks!

Find more posts tagged with

Sheets

Formulas

help

Countif

Accepted answers

Brian_Richardson

Yes, wildcards are badly needed. There's an enhancement request in Community that I encourage you to vote for.

https://community.smartsheet.com/discussion/102385/please-add-a-wildcard-function

That said, you can use CONTAINS often to accomplish what you need. Your formula would adjust to look like this:

=COUNTIFS({Papers Range 2}, CONTAINS("O'Malley",@cell), {Papers Range 3}, "1 - Published")

All comments

Brian_Richardson

Yes, wildcards are badly needed. There's an enhancement request in Community that I encourage you to vote for.

https://community.smartsheet.com/discussion/102385/please-add-a-wildcard-function

That said, you can use CONTAINS often to accomplish what you need. Your formula would adjust to look like this:

=COUNTIFS({Papers Range 2}, CONTAINS("O'Malley",@cell), {Papers Range 3}, "1 - Published")

bs786

Thank you Brian!

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.