Get latest row based on several criteria

[HPS]

I have an asset inspection app and have been using the following expression to get the most recent inspection result for a particular “asset id”:

([_THISROW] = MAXROW(“inspections”, “timestamp”, ([Asset_ID] = [_THISROW].[Asset_ID])))

Works perfectly.

Now I have learned that “Asset ID” is not unique, but may be repeated in a different category, e.g.
“asset 5” could appear within different categories as shown below. This is due to a legacy numbering system.

[category][subcategory][asset id]
Electrical > Tools > asset 5
Vehicle > Offroad > asset 5
IT > Laptop > asset 5

So what i would like to do is modify to:

([_THISROW] = MAXROW(“inspections”, “timestamp”, ([category][subcategory][Asset_ID] = [_THISROW].[category][subcategory][Asset_ID])))

but the appsheet help guide says this can’t be done.

Is there a solution to this?

[HPS]

Is the solution to create a computed column, combining all those fields

[Steve]

help.appsheet.com

AND()

Are all true?