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!
