Hey @Luke W. You're looking for the function combination of MIN and CHILDREN
MIN displays the lowest number, or in this case the earliest date.
CHILDREN indicates the subsequent rows in a hierarchy.
So if your data is setup like this...
https://us.v-cdn.net/6031209/uploads/LV4QBC4AAI1Q/image.png
You can use this formula to get the earliest date of the children of that parent...
=MIN(CHILDREN())
https://us.v-cdn.net/6031209/uploads/C7CM747CC28X/image.png
Does that help?
Parent Row to display Child Row value based on upcoming due date

I need to create a formula where the parent row determines what it displays in its cell based on the following criteria:
- Display cell data from the child row that has the earliest date
So 2 columns...
VNT and VNT Due
123 1/1/11
456 2/2/22
I want the VNT parent row to display the VNT child value that has the earliest date in VNT Due.
I hope that makes sense.
Thank you for any help!
Best Answer
Answers
-
Hey @Luke W. You're looking for the function combination of MIN and CHILDREN
MIN displays the lowest number, or in this case the earliest date.
CHILDREN indicates the subsequent rows in a hierarchy.
So if your data is setup like this...
You can use this formula to get the earliest date of the children of that parent...
=MIN(CHILDREN())
Does that help?
-
Hi @Ryan Sides, that makes sense for sure. I currently have the date part taken care of, just like in your example.
What I also need, is for the "123" to be displayed in the "Parent" Row/Cell of VNT, since that is the earliest date of "12/14/22".
-
That's what I needed! Thank you @Ryan Sides
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!