COUNTIFS and Date Range

I'm wondering if anyone can help. My formula below works great, but I want to adjust what's included in this count.

For this count I want to filter on current date date from a range in a column (Current Due Date).

e.g. date range 30/04/2019 to 30/04/2020

=COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2, {Project Status}, OR(@cell = "Shipped", @cell = "In Progress"))

I've been looking at the formula function help wiki for date functions : https://help.smartsheet.com/functions but hit a brick wall. Any recommendations on what function I should use?

Thanks.

Lindsay

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this...

=COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2, {Project Status}, OR(@cell = "Shipped", @cell = "In Progress"), {Date Range}, AND(@cell >= DATE(2019, 04, 30), @cell <= DATE(2020, 04, 30)))

Lindsay Wilson

@Paul Newcome This worked thank you!

Lindsay

All comments

Paul Newcome

Try this...

Lindsay Wilson

@Paul Newcome This worked thank you!

Lindsay

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