How do I add a date range formula to an existing formula?

MJ11120905

This is the formula I have built so far:

=COUNTIFS({EP DAR Data Input Tracker - Sheet (with Fo Range 1}, {EP DAR Data Input Tracker - Sheet (with Fo Range 2}) & "," AND({EP DAR Data Input Tracker - Sheet (with Fo Range 4}, ">=2025-01-01",{EP DAR Data Input Tracker - Sheet (with Fo Range 4}, "<=2025-31-01")

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

It looks like you are using Excel syntax. Try this instead (to include each @cell reference being left as is):

=COUNTIFS({EP DAR Data Input Tracker - Sheet (with Fo Range 4}, IFERROR(YEAR(@cell), 0) = 2025)

I removed the first two {Ranges} because you have no criteria for either of them. What is the purpose of those two ranges?

MJ11120905

Hello Paul -

What I am trying to do is pull information from a data input tracker column to be tracked by the date. I have a form setup that tracks all the data and one of the entries in the columns is dates.

For instance… if said column has multiple allowable entries from a form (Billy or Joe) I want to know how many times Billy was selected in that column and if it was between 01/01/2025 and 01/31/2025.

MJ11120905

If using the above data, the formula/data I want to track is the following:

How many times did Billy use the Honda Vehicle in the month of January?

How many times was there single coverage in the month of January?

Paul Newcome

In that case you would use the standard COUNTIFS (the one the the "S" on the end) syntax.

=COUNTIFS({Range 1}, criteria 1, {Range 2}, criteria 2, {Range 3}, criteria 3)

https://help.smartsheet.com/function/countifs

MJ11120905

Hey Paul -

I was able to create the formula that I was looking for which is the below:

=COUNTIFS({Logged By}, {Billy}, {Date Collected}, AND(@cell >= DATE (2025, 2, 1), @cell <= DATE(2025, 2, 28)))

Now i would like to utilize that same count/date range but add in to the formula how many times Billy used the Honda.

In summary - How many times Billy was the person who logged the information in the month of January for using the Honda.

Paul Newcome

You would just need to add another range/criteria set following the same syntax outlined above.

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.