Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Finding the Next Upcoming Date in a Rollup Field

Topic Labels: Formulas
143 2
Showing results for 
Search instead for 
Did you mean: 

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:

Screen Shot 2022-09-13 at 10.06.09 PM

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?

2 Replies 2

Hi @maradas, since each date field is its own record, what if you used a formula field to calculate the number of days between TODAY() and the date value?

From there, you could use a rollup field to get the lowest number of days and use that value to get the closest date

Edit: Ha, please ignore my suggestion and use Kamille’s solution below, it’s much much better

Set your Rollup field to only pull records that meet a condition: Date is after Today

Then use the MIN(values) aggregation.

Screen Shot 2022-09-13 at 11.52.14 PM