Find latest row that matches these criteria

[SKETCHwade]

Hi,

I am trying to create an expression that I can use in a columns initial value.
I want it to return the latest row that matches column Equipment.
I have this:

ANY(
SELECT(Pre Start[Equipment],
([_ROWNUMBER] = MAX(SELECT(Pre Start[_ROWNUMBER],
([_THISROW].[Equipment] = [Equipment]))))))

Which is interpreted by appsheet as:

One randomly chosen value from this list (
…The list of values of column ‘Equipment’
…from rows of table ‘PRE START’
…where this condition is true: ((The value of column ‘_RowNumber’) is equal to (MAX(
…The list of values of column ‘_RowNumber’
…from rows of table ‘PRE START’
…where this condition is true: ((The value of ‘Equipment’ from the row referenced by ‘Timestamp’) is equal to (The value of column ‘Equipment’))))))

I tried to do this:
ANY(
SELECT(Pre Start[Equipment],
AND(([_ROWNUMBER] = MAX(SELECT(Pre Start[_ROWNUMBER]))),
([_THISROW].[Equipment] = [Equipment]))))

But the select function becomes invalid

Any ideas on how I could select the latest row where equipment matches equipment?