How do I exclude closed issues from chart?

Hello Smartsheet Community!

I have created a chart that displays all issues to date, but I need one that also shows only the open issues. How do I set that up in the metrics to display correctly in Smartsheet dashboard? The original reference is from a column with a dropdown that includes "Resolved/Closed" as a status.

See below (chart display includes all issues, but I want to exclude "Resolved/Closed":

Thank you for any assistance you can provide!

April

Find more posts tagged with

Accepted answers

Paul Newcome

You would add another range/criteria set to your COUNTIFS.

=COUNTIFS({Range 1}, "High", {Status}, @cell <> "Resolved/Closed")

All comments

Valdeir Faria F.

You can remove the resolve/Closed category from your data source. If that is a data that must be shown, you can dedicate a widget just for that data.

April Tucker

Hi Faria,

Thank you for the response! Unfortunately, I cannot simply exclude it from my data source without a formula to do so. The display I want to show is from a column that includes the severity level (critical, high, etc.) of all the solution status items listed on the left (not started, IT review, etc.). For me to show only open items from that list, I need to remove "resolved/closed" from the column list (which is impractical).

Below is the formula for displaying the severity level as a metric - I would like to know how to associate the "severity" level and the "solution status" columns and then exclude "resolved/closed" from the data set so that the chart only displays the severity level of open items versus all items in the severity column (which would include resolved/closed items).

Essentially, how do I add and remove from the columns? Solution Status plus Severity (Test Master) minus "Resolved/Closed" from Solution Status options? Do you know how to adapt the formula to do exclusions from a column list?

Best regards,

April

Paul Newcome

You would add another range/criteria set to your COUNTIFS.

=COUNTIFS({Range 1}, "High", {Status}, @cell <> "Resolved/Closed")

April Tucker

Hi Paul,

That worked!! Thank you so much.

Yours truly,

Novice user :)

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, 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.