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!!
Answers
-
=MAX(COLLECT(Date:Date, Number:Number, Number@row))
Hi, @Bradley CO , your ranges are transposed. Here's documentation on the COLLECT() function.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!