Pulling Latest Date Data From another sheet

kward · 01/08/24

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)

Paul Newcome · 01/08/24

There is no MAXIFS or FILTER function within Smartsheet. Try a MAX/COLLECT combo instead.

kward · 01/08/24

I tried

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

and

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

and the same result

Paul Newcome · 01/08/24

It would just be a MAX/COLLECT. No VLOOKUP or INDEX or anything else if you are just trying to pull the date.

You also need to make sure you are creating your cross sheet references properly.

Answers