Hello Everybody I have a virtual column that

[Jason_F]

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)

[pravse]

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.

[Steven_Coile · Accepted solution]

MAXROW() help.appsheet.com

[Jason_F]

Thanks, Worked