Dates of Parent

Alex Klingbeil

so I am looking to make something and I cant seem to find what I need.

I would like to use

EXAMPLE

Parent Date | =last date entered below or keep blank tell all Childs are filled in

Child Date 1 | 1/1/22

Child Date 2 | 12/25/21

Child Date 3 | 11/9/21

Child Date 4 | Blank

i know =MAX(CHILDREN()) will kind of work but it wont leave it blank

Devin Lee

Hey @Alex Klingbeil,

One solution is to include an IF statement with a COUNT to compare the number of CHILDREN from one column to the other. If they match it will continue with the MAX formula and if they don't it will return blank.

=IF(COUNT(CHILDREN(Date@row)) = COUNT(CHILDREN([Column A]@row)), MAX(CHILDREN()), "")

Devin Lee

Hey @Alex Klingbeil,

One solution is to include an IF statement with a COUNT to compare the number of CHILDREN from one column to the other. If they match it will continue with the MAX formula and if they don't it will return blank.

=IF(COUNT(CHILDREN(Date@row)) = COUNT(CHILDREN([Column A]@row)), MAX(CHILDREN()), "")