Index/Match with Minimum value


Hello Community,

What I'm trying to do is use a Helper Sheet to pull two values from other sheets based on a name match.

My Helper sheet has a list of names and a few other columns, two of which I'm using to try and pull the earliest date from two other sheets. Those sheets are a Scheduler and PTO Request form.

As such, my current code to pull a date matched to the name is:

=INDEX({Scheduler - Date Start}, MATCH([Employee Name]@row, {Scheduler - Name}, 0))

As the PTO and Scheduler are unsorted, this will pull whichever one it finds first, but what I want to do is find the earliest date in this unsorted list for the person who's name matches. Both sheets will have an archiving function to remove PTO and Schedule dates after that date is over, so the newest minimum date will always be something else.

Any help would be appreciated, thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!