Hi Tiller Community,
I’m having an issue with the Property Rental Manager template and hoping someone can help.
Here’s my situation:
- I did a FRESH install of the Rental Manager (deleted the old broken one)
- The fresh install only has 2 rental columns (did not add extras yet)
- My Categories sheet has correct group names: 10 Gump, 100 Meadow, 101 Parmenter, 882 Main
- My income and expense categories are all correctly assigned to these groups
The problem:
- When I select an Income Group in row 18 (e.g. ‘10 Gump’) → the Total Income cell (C22) immediately shows #REF!
- When I select ONLY an Expense Group in row 19 → no error appears
- The formula in C22 is: =SUM(INDIRECT(AD3))
- Cell AD3 is completely empty — there is nothing to the right of column O on my sheet
It seems like the Income Group selection triggers a lookup to AD3 which doesn’t exist. Is there a named range or helper column that’s supposed to be in AD3? Did something not install correctly?
I have screenshots showing:
- The #REF error appearing when Income Group is selected
- No error when only Expense Group is selected
- The formula bar showing =SUM(INDIRECT(AD3))
Any help would be greatly appreciated! Thank you.
I just installed the rental manager to see if I could help. When I entered income, I also got the #REF error. Mine was solved when I inserted a few rows beneath the income because the error was the array could not be expanded. Can you check to see if that is the error you get? (You can hover over the error cell and it will pop up the description of the error)
If not, can you share the error. Though it looks like you have at least five lines below the income; do you have your income group with many sub accounts?
Expanding the rows expanded the array. BUT …
I’ve been troubleshooting my Rental Manager for a while and I’ve finally pinpointed the exact problem. Hoping someone can help me fix it!
HERE IS THE EXACT ISSUE:
The amount cells in the Rental Manager use this formula:
=ARRAYFORMULA(IFNA(VLOOKUP(E32:E34,$T:$U,2,FALSE),IFERROR(1/0)))
This formula looks up values from columns T and U. BUT — columns T and U DO NOT EXIST on my sheet. My sheet only goes to column I. The helper columns were never created during installation.
BECAUSE OF THIS:
- All rental income shows $0 even though the transactions exist and are correctly categorized
- I can confirm the transactions ARE in my Transactions sheet with correct categories and groups
- I can confirm my Categories sheet has correct Group and Type assignments
- The data is perfect — the template is broken
WHAT I HAVE TRIED:
- Fresh install of Rental Manager (deleted old broken version)
- Correctly set Income Group, Expense Group, and Deposit Group for all rentals
- Inserted extra rows to fix array expansion errors (that part is now working)
- Verified all category names, group names, and types are correct
QUESTION:
How do I get columns T and U (the helper columns) to install correctly on my Rental Manager sheet? Is there a way to manually add them or do I need to reinstall the template a specific way?
Thank you!
T and U should be part of the sheet when created. If it was like mine, then you should see this little arrow next to the I - click that arrow and it will open the hidden columns, which are hidden by default as they are helper columns and shouldn’t be changed as a general practice. Before you do anything else, did you try adding a few rows to see if it changed the error? Your formula is not the same as mine, but I just downloaded the sheet this morning to see if I could help.
The arrow revealed the hidden columns. Here is a detailed summary of exactly what is happening and what I have found.
MY SETUP:
- 4 rental properties: 10 Gump, 100 Meadow, 101 Parmenter, 882 Main
- Fresh install of Rental Manager
- All Income Groups, Expense Groups, and Deposit Groups are correctly set
- All category names, group names, and types (Income/Expense/Transfer) are correct on Categories sheet
- Transactions are correctly categorized and confirmed present in Transactions sheet
THE MAIN PROBLEM — Income shows $0:
- Rental Income 10 ($5,580 YTD) shows $0 in the Rental Manager Income section
- Same for all other rental income categories
- I confirmed the helper columns (T and U) DO have the correct amounts — Rental Income 10 shows $5,580 in column U
- BUT the cells next to the income category names in the Income section are COMPLETELY BLANK — no formula at all
- The expense cells DO have this working formula: =ARRAYFORMULA(IFNA(VLOOKUP(E32:E34,$T:$U,2,FALSE),IFERROR(1/0)))
- The income cells have NO formula — they appear to have never been populated during installation
OTHER ISSUES I HAVE NOTICED:
- When I first set the Income Group dropdown, I get a #REF error that says the array cannot expand — I fixed this by inserting extra rows between sections
QUESTIONS:
- Why are the income amount cells blank with no formula? How do I add the correct formula to make income show up
I have screenshots of everything described above and am happy to share them. Thank you so much for your help!
={"Income - "&if(isblank(E$8),E$7,E$8);IF(ISBLANK(E18),IFERROR(1/0),IFERROR(ARRAYFORMULA(SORT(FILTER(INDIRECT($R$8),INDIRECT($R$9)=E18))),IFERROR(1/0)))}
This is the formula in E22 on my sheet (where the income populates) Can you see if entering that changes what you see? I am not sure why your sheet would have a different formula than mine as we both have fresh installs. I am a little stumped on this one.
Entering that formula in E22 creates an error. Does anyone know why the Income column is pulling in expenses and the expense column is pulling in income?
Well shoot, I really have no idea. At this point, I think your best bet might be to email support at support@tiller.com - I wish I could help. Sorry.
'll do that and post any solutions here. You’ve been super helpful! Thank you!
