Copper Contributor

So I need a solution, I can't see what it might be. I have some data and I need to record savings by month. The only data I have to work with is the savings total, when the contract will start, the duration of months. So I can do the total saving  / contract duration, which gives me my monthly saving.

But then how do I populate these monthy savings into a table, for it to pick up only the number of months from the start date to populate?Screenshot Test.png


Screenshot 2024-02-19 212850.png

1 Reply

@Danny Hooper 

In cell A6:


In cell A9:



In my example i've entered these formulas in cells A6 and A9 and filled them to the right. Perhaps this is similar to what you are looking for.

savings tracker.png