Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Newest date in children input text
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)
Comments
-
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
-
Sorry for the late reply.
Thank you! It is working as it should!