CountIFs projects are within a date range.

Hello,

Need assistance, I am referencing a second sheet and I am attempting to count all projects that are estimated to start within 30-60 days. The second criteria is that I only want to count the cells that have a blank cell under the Actual date.

I have used the following and receive error =COUNTIFS({Tracker (BAU) Range 2}, AND(@Cell >= TODAY(31), @cell <= TODAY(60)),{Tracker (BAU) Range 3}, ISBLANK(@cell))

Thank You,

Find more posts tagged with

Accepted answers

All comments

Alex Argumedo

Hi,

You can use automation to solve this issue

Alexi Resendiz

I am attempting to add this to a Metrics sheet so I can add this metric to my dashboard

Alex Argumedo

https://community.smartsheet.com/discussion/comment/294572#Comment_294572

Automation should work on any sheet, you can also create an "auxiliary" column (hidden) in your source sheet, then pull the column to your Metrics sheet, apply the automation, and then get that column for your dashboard from your Metrics sheet

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.