nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Formula for a metric count from a column with multi-value cells

KP13

Good day! I am trying to create a formula to metric count instances of an issue phrase. The column allows for multiple issues to be selected by users. There are two other parameters for the metric, each is a single-value column. The formula I am using is:

=COUNTIFS({HOPE correction /SFV tally Org}, Org@row, {HOPE correction /SFV tally Month 2}, "y", {HOPE correction /SFV tally Issue}, HAS([Primary Column]@row))

The multi-Value column is {HOPE correction /SFV tally Issue}.

Currently Months 1 & 2 have no values (it is a new audit), but month 3 does. When I input the formula in for Month 3, I get the error #INCORRECTARGUMENTSET

I had a similar issue on another metric sheet where I got an #INCORRECTOPERATION error.

I appreciate the help to figure out where I am going wrong.

Find more posts tagged with

Non-profit

Sheets

Healthcare

Formulas

Countif

Accepted answers

Paul Newcome

You need to include the "range" to evaluate in the HAS function. Since the range is already established with the cross sheet reference, you would use "@cell" (case sensitive) to tell the formula to evaluate that range on a cell by cell basis.

=COUNTIFS({HOPE correction /SFV tally Org}, Org@row, {HOPE correction /SFV tally Month 2}, "y", {HOPE correction /SFV tally Issue}, HAS(@cell, [Primary Column]@row))

All comments

Paul Newcome

=COUNTIFS({HOPE correction /SFV tally Org}, Org@row, {HOPE correction /SFV tally Month 2}, "y", {HOPE correction /SFV tally Issue}, HAS(@cell, [Primary Column]@row))

KP13

Thank you! That did the trick!

Paul Newcome

Happy to help. 👍️

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, category/bannerUrl, category/bannerImageAlt, category/extensions, category/customizationLabels, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/bannerImageAlt, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.