Help

Extracting Earliest Date in a Rollup Field

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
366 4
cancel
Showing results for 
Search instead for 
Did you mean: 
LaurenMaine
5 - Automation Enthusiast
5 - Automation Enthusiast

I looked for other solutions on the forum and either I'm too much of a novice to know how to solve it or it didn't work for my problem. I have a rollup field that is collecting multiple dates. I'd like to have it only return the earliest date in the list.  Is that possible?  I tried using MIN(values), but only got a 0 in the field.  Thanks!

1 Solution

Accepted Solutions
Dan_Montoya
Community Manager
Community Manager

Mine worked with the date fields being a lookup field (yours is a rollup). Then do a rollup on the lookup.

See Solution in Thread

4 Replies 4
Dan_Montoya
Community Manager
Community Manager

Screenshot 2024-03-19 at 4.13.26 PM.png. You can do a rollup of your dates field and take the minimum one.

Screenshot 2024-03-19 at 4.15.10 PM.png

Yes, I tried that, but I get only a 0 as the value in the cell...

Dan_Montoya
Community Manager
Community Manager

Mine worked with the date fields being a lookup field (yours is a rollup). Then do a rollup on the lookup.

LaurenMaine
5 - Automation Enthusiast
5 - Automation Enthusiast

Great, thanks!