How to pull in MAX Date based for "Charter Approved" and "Project Baselined" when they are 100%?

Hey folks,

I'm looking to pull in the MAX Date for when:

• Charter Approved is Dated and 100% Complete

• Project Baselined is Dated and 100% Complete

For the screenshot below, the date pulled in should be 10/05/2021

I'm not sure if it matters but the formula is going into a Text cell.

Thank you!

Find more posts tagged with

Accepted answers

All comments

You might run into a hiccup here because using the MAX formula for a date requires that the result be entered in a Date field. You can see that in the usage notes here:

Usage Notes

When referencing dates, you must use MAX in a Date column. See Column Types for more information on Date columns.

The formula you're looking for should be an IF/AND statement, I think. Something like:

=IF(AND([Percent Complete]5 = 1, [Percent Complete]9 = 1), MAX([Start Date]:[Start Date]))

Where 5 and 9 are the row numbers for the Charter Approved and Project Baseline rows respectively.

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.