Formula Help! Adding Values in child rows based on date range

I'm trying to add the values entered in all child rows in a column, based on the date range (by quarter):

=SUMIFS(CHILDREN([PT Total Hours]@row ), CHILDREN(Date@row ), ">=01/01/2025", CHILDREN(Date@row ), "<=03/31/2025")

This is what the AI formula came back with, also what another external AI platform came back with. Every date format I try, returns 0, but the correct value should be 27.5

Screen Shot 2025-06-17 at 3.50.41 PM.png

Find more posts tagged with

Accepted answers

Darren Mullen

@jmaxbr Sounds like those AI's need to be retrained ha.

You need to use the DATE() function

=SUMIFS(CHILDREN([PT Total Hours]@row ), CHILDREN(Date@row ), >= date(2025,1,1), CHILDREN(Date@row ), <= date(2025, 3, 31))

jmaxbr

Got it, using date(2025, 1, 1) and date (2025, 3, 31. Thank you!

Darren Mullen

@jmaxbr Agh. Sorry! You figured it out. I didn't double check before I hit post!

All comments

Darren Mullen

@jmaxbr Sounds like those AI's need to be retrained ha.

You need to use the DATE() function

=SUMIFS(CHILDREN([PT Total Hours]@row ), CHILDREN(Date@row ), >= date(2025,1,1), CHILDREN(Date@row ), <= date(2025, 3, 31))

jmaxbr

Got it, using date(2025, 1, 1) and date (2025, 3, 31. Thank you!

Darren Mullen

@jmaxbr Agh. Sorry! You figured it out. I didn't double check before I hit post!

jmaxbr

I would not have figured it out without the second date! Much appreciated.

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.