But, in my case, the Cash Flow Forecast is not pulling any info from my Categories. Income, Expenses and Cash Flow are listed in rows 11-13 as $0.
Given that I’ve only just added these community add-ons, is there a way for me to fix this that doesn’t involve deleting things and starting again?
In the meantime, this is great for my self esteem because it means the Retirement Planner currently says I’ll be worth tens of millions of dollars at retirement. But that’s really because it thinks I’m investing 100% of my income and not spending any of it on expenses.
I changed it to the one that you shared above, and still got a #REF error. It returned to the same old error message as before, and said:
Error Function ARRAY_ROW parameter 2 has mismatched row size. Expected: 206. Actual: 1.
So then I went to check AG24-26 and mine we also different to what you listed above. It was a bit hard to understand because, in my sheet, AG25 has nothing listed - this cell has a heading in it, rather than a formula.
I’ll share a picture in the hopes this captures it. Ultimately, what I hope the picture shows is:
AG23 = Categories!C2:C
AG24 = Categories!D2:D
AG25 = “Current Calendar Year” heading
AG26 = Categories!F2:F
It doesn’t seem to say “Categories!A2:A” in any of the cells in column AG, from what I can see.
You likely deleted a row in the Live Events section, which deleted important information in the hidden part of the cell.
What was on row 24 in the original template included the Column Lookup information for the Category column. Without that row, you will get the #REF and other errors.
To fix this, you need to re-install a clean version of the Cash Flow Forecast sheet.
If you put a lot of work into your current sheet, you might rename that one as Old Cash Flow sheet so you can save the data. But you will need to put in the data on the new sheet.
I believe there were some instructions about not deleting rows in the live events or any section of the sheet. I’ll add that to the doc file you linked to above.
It’s best just to overwrite data, because if you delete a row, you might delete needed formulas in the hidden part of the sheet.