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

jmaxbr

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

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!

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.