formula like MAX, but that grabs the top three?
I have a sheet that collects project updates per project, and I want to surface the most recent three updates per project for a report. So the data is really simple, there is a date and an incrementing autonumber, so I can use either of those for the metric.
Table has these fields, so pretty basic stuff:
ProjectName; Update Text; ID; Date
When I have done this in SQL, it is a matter of getting the MAX, for a project, then getting the MAX for a project where ID is less than the MAX, and then getting the MAX for a project where ID is less than that second-Max. That get the top three. And that's effectively a query in a query in a query.
Is there a way to pull this off in Smartsheet?
Help Article Resources
Check out the Formula Handbook template!