The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

# Re: Find Most Recent Date across Rollup Fields

Solved
3328 0
cancel
Showing results for
Did you mean:
4 - Data Explorer

Is it possible to use a formula or some other work around to find the most recent date across 4 rollup columns? See photo. I'd like the left column to then show the most recent date, the 4 columns are different donation platforms and it'd be helpful to summarize that info to one single column showing most recent date regardless of the donation platform.

1 Solution

Accepted Solutions
18 - Pluto

I don't recommend using a formula that involve the TODAY() function. That function can be resource intensive because it recalculate every few hours even if no other data has changed.

I recommend the formula described here.

4 Replies 4
10 - Mercury
Step 1: Calculate the most recent date as the number of days before today. I called mine "Most Recent Date of All"

``MAX(DATETIME_DIFF({Date 1 Rollup},TODAY(), 'd'), DATETIME_DIFF({Date 2 Rollup},TODAY(), 'd'), DATETIME_DIFF({Date 3 Rollup}, TODAY(),'d'))``

Step 2: Subtract that number of days from today

``DATEADD(TODAY(), {Most Recent Date of all}, 'd')``

Here it is in one big happy formula

``DATEADD(TODAY(),MAX(DATETIME_DIFF({Date 1 Rollup},TODAY(), 'd'), DATETIME_DIFF({Date 2 Rollup},TODAY(), 'd'), DATETIME_DIFF({Date 3 Rollup}, TODAY(),'d')), 'd')``

4 - Data Explorer

getting closer! Thanks. It appears that the expected behavior works (day +1) when both columns have data, but when there is data in only one or the other then the result is todays date.

18 - Pluto

I don't recommend using a formula that involve the TODAY() function. That function can be resource intensive because it recalculate every few hours even if no other data has changed.

I recommend the formula described here.

10 - Mercury

Thanks for the info about the TODAY() function. I didn't know that. Appreciate it.