Count the number of "In Progress" within the last 30 days

I need to count the number of "In Progress" request that were created within the last 30 days in a referenced sheet, in a separate metrix sheet. Below is what I tried to use.

[Primary Column]@row equals "In Progress"

=COUNTIFS(({SD - Request Tracker Range 1}, [Primary Column]@row), ({SD - Request Tracker Range 2}, <= 30))

Find more posts tagged with

Accepted answers

Paul Newcome

It looks like you have some extra parenthesis tucked in there. Lets start by cleaning a few things up to see if that helps any...

=COUNTIFS({SD - Request Tracker Range 1}, [Primary Column]@row, {SD - Request Tracker Range 2}, @cell <= 30)

All comments

Mike TV

@SmartSheet Newbie

Please provide a screenshot of both sheets (without sensitive data) so we can see what column names you're working with.

SmartSheet Newbie

Paul Newcome

It looks like you have some extra parenthesis tucked in there. Lets start by cleaning a few things up to see if that helps any...

=COUNTIFS({SD - Request Tracker Range 1}, [Primary Column]@row, {SD - Request Tracker Range 2}, @cell <= 30)

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.