Formula to collect most recent date

Hi,

I am trying to reference a column from another sheet to return the next availibility date, which is going to be 9/19/23 in the attached screenshot. I have tried the formula below, but am having trouble getting the formula to work.

=MIN(COLLECT([Release Availibility Date], [Release Availibility Date], [Release Availibility Date], [Release Availibility Date], >TODAY()))

Thanks!

Find more posts tagged with

Accepted answers

Paul Newcome

Make sure you are putting the formula into a date type column.

All comments

Paul Newcome

You will need to create cross sheet references for the ranges.

=MIN(COLLECT({Date Range}, {Date Range}, @cell> TODAY()))

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

shuang

Hi,

I inputed the formula below, but I got an invalid column value.

=MIN(COLLECT({Release Availibility Date}, {Release Availibility Date}, @cell > TODAY()))

Thanks!

Paul Newcome

Make sure you are putting the formula into a date type column.

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.