Compound interest with variable contributions

[Jeff_Hager]

To do the same thing that you do in Excel, you probably want use case number 2 in this post to get a row number.

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

Once you have that, create a math column to subtract 1 from that row number.

Then create a Single Value column, Get: ‘From start’, Row: ‘math column’, From: ‘Table->Whole Row’.

Finally create a lookup to retrieve the previous row value from the single value column.