Updating years in Google Sheet

Google Sheets
,
1

I cannot figure out how to update the years on some of the tabs on Google Sheets. The year is correct for many of them (Yearly Budget, Monthly Raw Expenses…) but it’s wrong on the Categories tab (2020-21) andYTD Analysis tab (but only in the bar graphs).

Any idea how to correct those? Thank you!

2

Welcome Seth :slight_smile:

For the Categories tab, follow this section in the Multi-year Budgeting in the Tiller Foundation Template | Tiller Help Center to add additional months/years. This will get used by some other solutions/sheets.

Set up your 12 additional months

  1. Open your Tiller Foundation Template
  2. Navigate to the Categories sheet
  3. If you haven’t already, expand the budget month columns
  4. Select column E and hold the shift key and then select column P. This assumes that column E is the first month you have set and P is the last month you have set.
  5. Right click and choose “Insert 12 right” to insert 12 blank columns to the right of the current budgeting year’s month columns.
  6. Use the fill handle to pull and fill the contents of the month for the last year into the 12 blank column headers. This should create 12 new budget months. The budget months should be formula driven and look like this =eomonth(E1,0)+1 where E1 in the formula is the previous month’s cell.
1 Like