Pulling Latest Date Data From another sheet

Options
kward
kward ✭✭
edited 01/08/24 in Formulas and Functions

Hello all,

I'm trying to have one sheet pull the latest Date from another sheet, where a specific name is in the Name column.

This is the formula I can't get to work. It receives a #unparsable error.

=INDEX('Sheet Name'!Date, MATCH(MAXIFS('Sheet Name'!Date, 'Sheet Name'!Name, "Employee Name"), 'Sheet Name'!Date, 0))


I have also tried the following using VLOOKUP:

=VLOOKUP(MAX(FILTER('Building Time Tracking'!Date, 'Building Time Tracking'!Name = "Employee Name")), 'Building Time Tracking'!Date, 1, false)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!