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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!