Maxrow timestamp

[reggieneo]

there is a sure value in my return value. but this formula is not giving anything:
"Any(select (Table[return value], [Timestamp]=Maxrow(Table,Timestamp)))

what I am missing here?

thanks

[Steve]

Unless the Timestamp column is the key column, you’re using MAXROW() incorrectly:

help.appsheet.com

MAXROW()

Row with greatest value in column

Perhaps you want MAX() instead?

help.appsheet.com

MAX()

Highest item in list

[reggieneo]

oh yes that explains the relationship with maxrow timestamp that is not my key column. thanks again. i will read more of the documentation.