Formula Help For Multiple Tags Within The Same Cell

Hey All!

First time posting... so here goes... I am attempting to write a formula that references another sheet, looks at a specific column, and then 'finds and counts' all the instances of a specific tag.

For example, the intake form allows multiple 'characteristics' to be chosen when describing a call. These characteristics populate within the tracking sheet in the column entitled 'Call Characteristics'. Then, the Dashboard Metrics sheet aggregates the data in various ways that show on the dashboard. **Please note! I am not the creator of this. I was asked to continue/maintain it's current state (which is NOT recommended as all these metrics should belong in various reports).**

I digress...

Is there a formula I can use that will reference another sheet, count all the categories with a specific label (even if there are multiple categories within a cell) and return an accurate count? i.e =COUNTIF({Client Business Sim LIVE Call Characteristic}, Description@row)

Any help/suggestion(s) is incredibly appreciated!

Call Categories Dashboard_Image_2023-09-28.png

Call Categories Metrics_Image_2023-09-28.png

Find more posts tagged with

Accepted answers

DKazatsky2

Hi @EmRo ,

Trying using the HAS() function in your formula.

=COUNTIF({Client Business Sim LIVE Call Characteristic}, HAS(@cell, Description@row))

Hope this helps,

Dave

All comments

DKazatsky2

Hi @EmRo ,

Trying using the HAS() function in your formula.

=COUNTIF({Client Business Sim LIVE Call Characteristic}, HAS(@cell, Description@row))

Hope this helps,

Dave

Danielle Arteaga

You need a COUNTIF/CONTAINS formula:

=COUNTIF({named range on sheet you want to cross reference}, CONTAINS("Warm Transfer", @cell))

(I don't know the name of the sheet that has the data you want to count, but that's what goes in the {})

For more on the CONTAINS function: https://help.smartsheet.com/function/contains

EmRo

Thanks Dave and Danielle! The HAS function worked perfectly! Super appreciate the feedback! :)

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.