Need to add additional Criteria to Metric Formula

I have a Metrics Sheet (named "Escalation Metrics") where I could up all my metrics (most are words rather than numbers. so this allows me to easily create a dashboard based on data that does not contain numbers. My current formula is:

=COUNTIF({Type of Escalation}, [Metric Name]@row)

And I want to add the criteria that the "Status" must be "Open". When I try to add this to the end:

, {Status}, ="Open") I get error messages. That last portion was taken from an Aging metric, which requires one of the criteria to be that the status is Open.

Thanks in advance!!!!!

Find more posts tagged with

Accepted answers

Sherry Fox

@Paul Newcome ,

I have been re-doing the formula since I last replied. It finally worked!!!!! My corrected formula is:

=COUNTIFS({Type of Escalation}, [Metric Name]@row, {Status}, ="Open")

The previous one I did that resulted in Unparsable was the following. I have bolded the ")" which was the difference and caused the problem. Thanks for your help!!!!!

=COUNTIFS({Type of Escalation}, [Metric Name]@row), {Status}, ="Open")

All comments

Paul Newcome

Did you update the function to a COUNTIFS (with the "S" on the end) when you added the new range/criteria set?

Sherry Fox

@Paul Newcome ,

No, I had not (duh!). I just tried, and changed my formula to:

=COUNTIFS({Type of Escalation}, [Metric Name]@row), {Status}, ="Open")

And the result is Unparsable. It still will not work properly.

Sherry Fox

@Paul Newcome ,

I have been re-doing the formula since I last replied. It finally worked!!!!! My corrected formula is:

=COUNTIFS({Type of Escalation}, [Metric Name]@row, {Status}, ="Open")

The previous one I did that resulted in Unparsable was the following. I have bolded the ")" which was the difference and caused the problem. Thanks for your help!!!!!

=COUNTIFS({Type of Escalation}, [Metric Name]@row), {Status}, ="Open")

Paul Newcome

Happy to help. 👍️

Glad you got that parenthesis sorted.

Sherry Fox

@Paul Newcome ,

Just like with Excel, often the issue in "formula grammar". It took forever, but I would NOT give up! Thanks again for your help, greatly appreciated.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.