Hello all! I have a somewhat tricky formula question that I’ve been banging my head against the wall over. I have a rollup field that compiles a list of dates. I’d like to pull the next date from that rollup field; in other words, the upcoming date that’s closest in time to today. Here’s an example of the field:
And what I’m looking for is a formula field that will output the following:
Row 1: 3/11/2023
Row 2: 11/30/2022
Row 3:12/29/2022
Does anyone have any ideas?