Newest date in children input text

Someone_2

Hi everyone

Is it possible to automatically input data from all children regarding newest date to parent?

 

For example I have 10 children, with text and multiple dates in the same children row, I want it to automatically upon newest date in specified collumn in all children input the text in the text collumn from that children to parent? (screenshot)

Adam Overton

TL;DR:

=INDEX(CHILDREN(), MATCH(MAX(CHILDREN(Date1)), CHILDREN(Date1), 0))

 

Explanation:

MAX(CHILDREN(Date1)) finds the value of latest change

MATCH(that value, CHILDREN(date1), 0) tells you the relative row number of that value

INDEX(CHILDREN(), that match index) gives you the value in this column on that row number, which is what you wanted