Adding window functions to a spreadsheet
Summary
This Grist blog post explains how to implement running totals in a spreadsheet-like database tool using ordered lookups and PREVIOUS(), including examples for running balances, nearest matches, and multiple totals by group. It compares with traditional spreadsheets and SQL window functions and demonstrates how Grist keeps balances correct when rows are added, moved, or removed.