Pulling Latest Date Data From another sheet

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)

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

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

kward

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

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.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.