Time relevant formulas

I want a figure to add the same figure to itself every week. For example
Week 1: 100
Week 2: 200 (100+100)
Week 3: 300 (200+100)

Does anyone have any suggestions? :slight_smile:

How are you currently adding rows for Week 2 and Week 3?

There’s currently only one row containing all of the values, so there is a “rent” column with a value but then I want this to increase on a weekly basis as the rent figure is used to show a ‘live’ income figure if that make sense…

So say you have one row and multiple columns of week 1, 2, 3, etc.?

1 Like