Find next / subsequent date in list
Options
ateleoh
✭✭
Hi, I am stumped. I am trying to figure out how to figure out the second (and third) date for each unique entry in the Provider/Resource column. I am using this formula to find the first date:
=IF(Date@row = MIN(COLLECT(Date:Date, [Provider/Resource]:[Provider/Resource], =[Provider/Resource]@row)), Date@row, 0)
Comments
-
Swap your MIN out for a SMALL.
=SMALL(range, n)
where n represents the nth lowest number within the range.
So
=SMALL(range, 2)
would provide you with the second smallest number, or in this case, the second date.
(LARGE works the same way for MAX)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!