Letter to Santa Claus, cc Coda

Agree with all of these!

As you may know though, there is a formula to find the previous row.


RowId column formula is thisTable.Sort().Find(thisRow) and PrevRow formula is thisTable.Filter(thisRow.RowId-1=RowId).IfBlank("")

Make sure the RowId formula sorts based on some column that is meaningful to you. There is no “canonical sort order” for a table. This one is sorting based on the Display Column, which is Name

1 Like