Formula to collect most recent date

shuang

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!

Paul Newcome

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

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.