Countifs Formula Including Keyword Search and Date Range

Hello,

I am attempting to build a live chart that tracks the number of open items from a smartsheet and also organizes them into date ranges based on todays date. I am currently using the countif function to organize the data into 30+ days outstanding, 60+ days outstanding, etc. but I would like to exclude any items that have been listed as complete. The current formula I am using is:

=COUNTIF({PurePM-Ron Weekly Tracker Range 3}, >=TODAY(-60)) - [30+ Days Outstanding]@row

Looking to organize the data based on the origin date and status columns.

Find more posts tagged with

Accepted answers

All comments

AravindGP

Hi @PPMRL

You will need to add the Status reference in your other sheet and set the criteria as <>"Complete", using the less than and greater than symbols in this manner takes is as not equal to. Your COUNTIF will change to COUNTIFS as there are multiple conditions.

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.