Improve this Expression?

AppSheet AppSheet Q&A
,
1

Can anyone please help me speed up this Expression?

I need to search the data for the last entry of the matching location:

INDEX(ORDERBY(FILTER(Toolbox,[Site]=[_THISROW].[Site]),[TimeStamp],TRUE),1)

I usually use maxrow() which is much faster, but in this case it has to also involve only the last matching site.

2

Does the following work

MAXROW(“Toolbox” , “TimeStamp”, [Site]=[_THISROW].[Site])

However, even if the above works, it may not be necessarily a much more efficient expression for sync time because it is anyway a multirow expression.