Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Extracting Earliest Date in a Rollup Field

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
1684 4
cancel
Showing results for 
Search instead for 
Did you mean: 
LaurenMaine
6 - Interface Innovator
6 - Interface Innovator

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
6 - Interface Innovator
6 - Interface Innovator

Great, thanks!