Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

✭✭✭✭✭
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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions