The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.
‎Feb 01, 2023 12:03 PM
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.
Solved! Go to Solution.
‎Feb 01, 2023 01:49 PM
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.
‎Feb 01, 2023 01:05 PM
MAX(DATETIME_DIFF({Date 1 Rollup},TODAY(), 'd'), DATETIME_DIFF({Date 2 Rollup},TODAY(), 'd'), DATETIME_DIFF({Date 3 Rollup}, TODAY(),'d'))
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')
‎Feb 01, 2023 01:12 PM
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.
‎Feb 01, 2023 01:49 PM
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.
‎Feb 01, 2023 02:05 PM
Thanks for the info about the TODAY() function. I didn't know that. Appreciate it.