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
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!
Help Article Resources
Check out the Formula Handbook template!