Right now I’m looking for a way to automate the calculated budget over active periods.
I tried the runningsum formula, but this only includes the budgets for months where something was spent. So let’s say the budget is 100, right now it’s july so month 7, should return in a cumulative 700 budget. Instead it returns 500, because nothing was spent in two months.
TL:DR - Is there a formula to multiply a value times the current month?
So f.e: budget = 100, right now it’s month 7, so a formula like: =[Budget]*CurrentMonth
Hope you guys can help… Feel like this should be possible