index / collect questions...

I'm trying to figure out how to find the last update in a column. The column does not always get updated when other columns do. I saw some similar looking formulas like =INDEX([Date/Time]2:Location10, MAX(COLLECT([Date/Time]2:[Date/Time]10, Location2:Location10, <>"")), 7) but they don't seem to work for me - i get invalid data errors.

I am not sure if i am even approaching this correctly - any help would be appreciated!!

Andra

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

=INDEX(Location2:Location10, MACH(MAX(COLLECT([Date/Time]2:[Date/Time]10, Location2:Location10, <>"")), [Date/Time]2:[Date/Time]10, 0))

All comments

Paul Newcome

Are you wanting to pull the most recently updated location?

AndraK

@Paul Newcome yes, i am wanting to pull the most recently updated.

Andra

Paul Newcome

Try this:

=INDEX(Location2:Location10, MACH(MAX(COLLECT([Date/Time]2:[Date/Time]10, Location2:Location10, <>"")), [Date/Time]2:[Date/Time]10, 0))

AndraK

@Paul Newcome that worked!! thank you so much!!

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.