Finding the most recent entry

I have tried finding the answer, but for some reason I can't seem to get the formula(s) to work for me. I have a sheet where other users update our fleet information using a form. I am trying to figure out how to find most recent date for each of our uniquely numbered ships. I keep seeing the formula Max(Collect, but I either get a 0 as a return or invalid column name/value, unparseable, etc.

Here is my data

So for the ship 3572 I have two dates 11/29/23 and 1/8/24. I need something that will give me 1/8/24.

I have tried the following:

=MAX(COLLECT(Number:Number, Date:Date, Number@row))

This outputs a 0. I tried changing the column with the formula into a date column, but then it doesn't return anything.

Does anyone have a solution or know how I can return the most recent date? I have even tried working with a helper sheet with a list of our fleet and trying the MAX(Collect()) that way with no success. Any help is appreciated!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!