Question regarding automatic date for parent row if all children have a date

dlreed13

This is what I have so far, but it populates the date if one out of (how many children) is filled in. IF(COUNTIFS(CHILDREN(), ISDATE(@cell)) > 0, MIN(CHILDREN()), "") I would like it to return the last date only if all the children have a date in their respective row. Thank you

Sam M.

Hi dlreed13,

I did some testing, and this might work.

In the cell that is green I have this formula:

=IF(COUNTIFS(CHILDREN(), ISDATE(@cell)) = COUNT(CHILDREN(Description@row)), MIN(CHILDREN()), "")

 

It checks if the amount of dates existing in the children is equal to the quantity of the children in the phase 1 section, then if it is equal it will display the minimum date, if you want the latest date you can use max().

Hope it helps,

Sam

Sam M.

Hi dlreed13,

I did some testing, and this might work.

In the cell that is green I have this formula:

=IF(COUNTIFS(CHILDREN(), ISDATE(@cell)) = COUNT(CHILDREN(Description@row)), MIN(CHILDREN()), "")

 

It checks if the amount of dates existing in the children is equal to the quantity of the children in the phase 1 section, then if it is equal it will display the minimum date, if you want the latest date you can use max().

Hope it helps,

Sam

dlreed13

@Sam M. That worked!!!!! Thank you very much. This pulled up the first date in the children, and I decided I would like to see the date everything was finished, so I changed the last part to MAX(CHILDREN()). Again, Thank you so much Sam

David Reed

Sam M.

@dlreed13 you're welcome!