# Parent Row to display Child Row value based on upcoming due date

Options
✭✭✭✭✭
edited 12/14/22

I need to create a formula where the parent row determines what it displays in its cell based on the following criteria:

1. 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!

• ✭✭✭✭✭✭
Options

@Luke W. You'll need to use INDEX/MATCH formula combo to find the CHILDREN. Place this on the parent row in the VNT column

=INDEX(CHILDREN(), MATCH([VNT Due]@row, CHILDREN([VNT Due]@row), 0))

Ryan Sides

Come Say Hello!

• ✭✭✭✭✭✭
Options

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?

Ryan Sides

Come Say Hello!

• ✭✭✭✭✭
Options

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".

• ✭✭✭✭✭✭
Options

@Luke W. You'll need to use INDEX/MATCH formula combo to find the CHILDREN. Place this on the parent row in the VNT column

=INDEX(CHILDREN(), MATCH([VNT Due]@row, CHILDREN([VNT Due]@row), 0))

Ryan Sides

Come Say Hello!

• ✭✭✭✭✭
Options

That's what I needed! Thank you @Ryan Sides

• ✭✭✭✭✭✭
Options

Glad to hear it! Happy to help

Ryan Sides

Come Say Hello!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!