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

✭✭✭

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

David L. Reed

Zeevo Group LLC

701 Fifth Avenue; Floor 42, Seattle, WA 98104 USA

Mobile: +1 253 250 5259

• ✭✭✭✭✭

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

• ✭✭✭✭✭

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

• ✭✭✭
edited 03/16/21

@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

David L. Reed

Zeevo Group LLC

701 Fifth Avenue; Floor 42, Seattle, WA 98104 USA

Mobile: +1 253 250 5259

• ✭✭✭✭✭

@dlreed13 you're welcome!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!