Only show latest row from each ID

Hi,

Below are 3 images, the first two are the google sheet the app is connected to. The second is the view within the app.

There are two versions of this app using the same sheet. One for operators to complete an inspection and the other for mechanics to fix issues raised from this inspection.

The app currently shows all rows in which the โ€œFixed?โ€ column is marked as false.
This is done with a slice row filter condition of:

AND([Fixed?] <> True,ISNOTBLANK([Fixed?]))

The issue you might notice is that it shows ALL rows with this condition, I would like to modify it to only show the latest row for each Equipment ID. The idea being a machine is only listed once for the mechanics, and within that is the latest information for the machine.

2 5 1,351
5 REPLIES 5
Top Labels in this Space