Formula to display next/upcoming date from a list


Hello, I'm looking to have a formula to display the next/upcoming date in the list. The formula is on another sheet (Sheet = "Helper Calculations"), so I need to reference another sheet (the one in the table below - Sheet = "Holiday Dates") within the formula. On this sheet, I can confirm the Date column is a Date type.

I was thinking it might look like this (below), but it returns #UNPARSEABLE.

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

To round things out, I would like the formula to output the 'Holiday Name', not just the date.

Any help is greatly appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!