Max Collect Formula for Dates in 1 row?

I have read other help articles, tried writing with AI and still could use some help in writing a formula for the following scenario.

I have three date columns. and want to return the value of the date that is the next date but in the future.

if the dates were:

10/1/25, 10/10/25 and 11/1/25 it would return 11/1/25. This would be true for whatever column the date in the future appears in.

I believe I need a Max collect but I just cant get it right. The latest formula I got from AI didn't work, and it is not a Max(Collect(…here is what I got.

=IF(AND(ISDATE([Date 1]@row ), [Date 1]@row > TODAY()), [Date 1]@row , IF(AND(ISDATE([Date 2]@row ), [Date 2]@row > TODAY()), [Date 2]@row , IF(AND(ISDATE([Date 3]@row ), [Date 3]@row > TODAY()), [Date 3]@row , "")))

Find more posts tagged with

Formulas

Accepted answers

Jgorsich

I think you'd want the minimum value that is in the future, rather than the maximum.

Skip the ISDATE() functions for now - just make sure that you are applying this to date columns only to test it. Make sure you are entering this function in a date column also or you'll get an error.

=min(collect([Column1]@row:[Column3]@row,[Column1]@row :[Column3]@row , >today()))

All comments

Jgorsich

I think you'd want the minimum value that is in the future, rather than the maximum.

Skip the ISDATE() functions for now - just make sure that you are applying this to date columns only to test it. Make sure you are entering this function in a date column also or you'll get an error.

=min(collect([Column1]@row:[Column3]@row,[Column1]@row :[Column3]@row , >today()))

Smar Czar

That was it @Jgorsich. Thank you!

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.