Hello Everybody I have a virtual column that

AppSheet AppSheet Q&A
1

Hello Everybody I have a virtual column that causes about 25 Second to be synced or calculated.

basicaly I need the last time that a pallet moved, using this fromula,

how can I make it faster or what am i doing wrong?

=Top(ORDERBY(SELECT(Move Pallet[MoveID], [PalletID] = [PalletID]), [TimeStamp], TRUE), 1)

2

That condition [PalletId] = [PalletId] seems wrong.

Try:

Top(OrderBy(SELECT(Move Pallet[MoveId], [PalletID] = [_THISROW].[PalletId]), [Timestamp], TRUE), 1)

There’s also a MAXROW function that makes this a bit easier.

3

MAXROW() help.appsheet.com

4

Thanks, Worked