Grist adds window functions for running totals in spreadsheets
Original title: Adding Window Functions to a Spreadsheet
Grist introduces PREVIOUS() and NEXT() functions to compute running balances and nearest matches that survive row insertions or deletions.
Grist, a spreadsheet-like database tool, now supports window functions including PREVIOUS(rec, order_by='Date') for running balances. These formulas automatically adjust to new or deleted records without manual fixes. Group_by enables per-cardholder balances, and RANK() identifies top transactions.
- PREVIOUS() computes cumulative totals by date or other fields.
- NEXT() and RANK() functions are available for additional queries.
- Formulas remain accurate after sorting or filtering.
- Works across multiple tables without per-row adjustments.
From the original article
6 min read at getgrist.com
Running totals, cumulative balances, and nearest matches: formulas between rows that stay correct. Here is a formula many of us wrote early on. Put transactions in a traditional spreadsheet, like Excel or Google Sheets, one per row, and keep a running balance: Copy the formula down, and it works.
By reedciccio · getgrist.com
A short excerpt; the article and its images belong to the publisher. Summary, key facts and assessment above are AI-written from the article and can be wrong.