MIN/MAX with Date and Time (Modified Date Column)


Hi all,

This should be straightforward but I am stumped!

How do I get the earliest (or latest) value including time from a Modified Date system column?


I can get the date if I define my output column as type Date and use a simple MIN/MAX but this means the time is ignored.

I thought about breaking the time and the date out into separate columns and using TIME formula and then MIN/MAX with COLLECT to do a multi-criteria search. But it seems awfully fiddly. Also a MIN with TIME is doing strange things with roundings.

Anyone got any tips?

Many thanks in advance.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!