Advanced formulas with ordered lookups
upcoming webinar
Sometimes you want to mosey down a table, row by row, and get a running total. Or you need a formula in the current record to use the previous one, or to find the last record before a certain date, or the first event of the next month. With Grist’s ordered lookups and functions such as PREVIOUS(), you can do cumulative calculations, nearest matches, and more. Join Dmitry, their implementor and Grist’s co-CEO, for a deep dive on Grist functionality that goes under the radar, but serves as a perfect and efficient tool for a range of data workflows.

