HAS Functions Returning 0

Hi Smartsheet Users,

I am struggling with the formula HAS with multiple selection drop down values and hoping I could get some guidance here.

Here, i would like to count how many "swimming" classes I have in a week.

The expected result is 3.

In the sheet summary, I have the formula written as

=COUNTIFS(Activities:Activities, HAS(Activities:Activities, "Swimming")). This gives me a "0" value result.

If I did a formula of COUNTIF without HAS, as below, it gives me a "1" value result.

=COUNTIF(Activities:Activities, "Swimming")

What did I do wrong?

Thanks

Syed

Find more posts tagged with

Formulas

Accepted answers

Syed Mohd Muhafzal

Hi all - this is good now. I needed to insert @cell in the formula and it works.

=COUNTIFS(Activities:Activities, HAS(@cell, "Swimming"))

Syed

All comments

Syed Mohd Muhafzal

Hi all - this is good now. I needed to insert @cell in the formula and it works.

=COUNTIFS(Activities:Activities, HAS(@cell, "Swimming"))

Syed

Andrée Starå

Hi @Syed Mohd Muhafzal

Excellent!

Glad you got it working!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Syed Mohd Muhafzal

Thanks @Andrée Starå . Feels so good when I got it worked at the end! Not so great the first few hours trying to figure it out though LOL. Hope you are doing well and keeping safe too!

Andrée Starå

@Syed Mohd Muhafzal

Yes, I can imagine the feeling!

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.