How Do I Capture The Most Recent Date From One Sheet Onto Another Sheet?

I am trying to pull the most recent date for a specific project into a cell on another sheet and have it update automatically when a new/most recent date is put in.

Ie. The 10/27/23 date is pulled to a master sheet and updates automatically when a more recent date is put in.

I used this formula, but it didn't work.

=MAX(COLLECT({Date}, {Project Name}, 5001 - Migration to OCI))

Sheet 1:

I went to my Sheet 1 and pulled the Date column first, then the Project Name column. I also changed the Column Type to Date on my Sheet 2.

Sheet 2:

Find more posts tagged with

Accepted answers

Paul Newcome

Try putting quotes around your text string there at the end.

All comments

Paul Newcome

Try putting quotes around your text string there at the end.

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.