Hello, I am building a financial planning app and I need to create a screen which has a list with 3 columns. The first column needs to be numbered 1-50. The second column 2021-2071 and the third column needs to calculate a dollar amount in each cell. The formula in each cell needs to reference the value of the previous cell.
So the formula in column 3, row 1 needs to be:
starting cash (queried from existing collection) * interest rate (also from existing collection) + starting cash + amount saved (calculated from summing values from existing collection).
then column 3 row 2 needs to be:
value of column 3 row 1 * interest rate + value of column 3 row 1 + amount saved (calculated from summing values from existing collection).
I have not been able to figure out to to display this on a screen, welcome any ideas.