Parent and Child Formula

Jolene

Is there a formula that can support a parent cell updating to the symbol that matches the last sequenced child that is filled in?

2023-03-20_10-23-03.png

Paul Newcome

Try this:

=INDEX(DESCENDANTS(), COUNTIFS(DESCENDANTS([Start_Date]@row), @cell <> ""))

Paul Newcome

Try this:

=INDEX(DESCENDANTS(), COUNTIFS(DESCENDANTS([Start_Date]@row), @cell <> ""))

Jolene

Thank you, Paul! That worked perfectly! I appreciate all of your help!

Paul Newcome

Happy to help. 👍️