Hi, I am struggling in getting the following formula to work. =SUMIFS({P-CARD Range 1}, {P-CARD Range 3}, AND(@cell>=DATE (2025, 1, 1), @cell =DATE (2025, 1, 1), @cell<=(2025,12, 31)) or YEAR (2025) I need it to pull data only within this date range or a specific year. Any help is appreciated greatly.

SUMIFS with multiple criteria and date range

Hi, I am struggling in getting the following formula to work.

=SUMIFS({P-CARD Range 1}, {P-CARD Range 3}, AND(@cell>=DATE (2025, 1, 1), @cell<=(2025,12, 31)), {P-CARD Range 2}, [15]150)

Range 1 = is a column with dollar values.
Range 3 = is a column with date values.
Range 2 = is a column with specific classification codes. The specific classification code in this instance will be displayed as a static value in cell [15]150.

My issue:
I can not get the following date range syntax to work properly.

AND(@cell>=DATE (2025, 1, 1), @cell<=(2025,12, 31))

YEAR (2025)

I need it to pull data only within this date range or a specific year.

Any help is appreciated greatly.

Find more posts tagged with

Accepted answers

Carson Penticuff

That is certainly possible. Is your date column formatted as DATE? I notice it is right aligned, and date columns default to left aligned unless changed.

All comments

Carson Penticuff

Give this a try:

=SUMIFS({P-CARD Range 1}, {P-CARD Range 3}, YEAR(@cell) = 2025, {P-CARD Range 2}, [15]150)

Konrad S.

Hi Carson, thank you for the input. By logic the formula you provided should have worked. I am getting an "Invalid Data Type" error.

Would it be possible that the dates in column Range 3 are not recognized as dates by Smartsheets, but rather some other type values?

Konrad S.

Here is a screenshot of where the data is pulling from (reference sheet location).

Carson Penticuff

That is certainly possible. Is your date column formatted as DATE? I notice it is right aligned, and date columns default to left aligned unless changed.

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.