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

Luke W.
Luke W. ✭✭✭✭✭
edited 12/14/22 in Formulas and Functions

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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!