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.
I don’t understand how you were able to get the ending cash to be used as the starting cash for the next year, can you share your app with me so I can see how you set it up?
In my opinion, you should use a bit different approach. Adalo is not an Excel, you can’t create tables with cross-referenced cells here quickly and efficiently. It’s simply a different instrument
And the list data itself is static and uses only the ID for the period and Year for year.
Referencing values from other entries in the list is possible in Adalo, though it could be quite complicated. I guess @Yongki has demonstrated you how this could be done.
Hi @Victor . THANK YOU THANK YOU THANK YOU! This is so amazing! Thank you! I got it to work just as you laid out.
There is one additional variable I’d like to include if at all possible. Basically, I’d like to add a constant amount each year and have that included in the compounding interest. So in simple terms it would be