INDEX/MATCH Most Recent Entry

I am trying to pull from a sheet that is essentially a list of new records that are entered weekly. To keep things clean I have a helper sheet that just lists the project name once and the rest of the columns pull in through an INDEX/MATCH. I am trying to have that helper sheet pull in only the most recent entry. There is a system generated column with the date. I am having trouble with the formula having it grab the most recent.

=IFERROR(INDEX({PERCENTAGE COMPLETE}, MATCH([Project Name]@row , {PROJECT NAME}, 0)), "")

Find more posts tagged with

Formulas

Accepted answers

All comments

DKazatsky2

Hi @John Loushin,

See if this works for you.

=INDEX(COLLECT({PERCENTAGE COMPLETE}, {PROJECT NAME}, [Project Name]@row , {CREATED}, MAX(COLLECT({CREATED}, {PROJECT NAME}, [Project Name]@row ))), 1)

Hope this helps,

Dave

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.