How do I auto fill a select box?

[cnr]

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. [image] 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

Also from the man himself

Running Total (Sum, Average, Median, etc)

This may help you as well:

Does that help?