I have have been using Tiller for a few months. Yesterday I put some work into it, I’ve been trying to edit my expenses and income, but for some reason the following error is now appearing when I try to click the “Fill” button using the sidebar:
" Failed to update Transactions with Error: “Error: Broken data validation references in column H must be repaired before updating your data feeds.”
Review this troubleshooting guide to fix the error and then click Continue and try updating your sheet again."
Have anyone faced this? I’ve tried to look into Column H of every sheet that I have and cannot find the problem or the solution .
In the “Transactions” sheet, Column H is “Linked Transfers”. This might be the cause of the issue, as when I try to choose one of the cells in this column, the dropdown menu only read “Loading…” and nothing really loads. Any Idea how to fix this?
Click on a cell in column H, go to the Data menu and choose ‘Data Validation’. From the window that appears on the right, click the rule for column H. The Criteria range should be ='Linked Transfers'!$O$2:$O. Of course this assumes you still have the Linked Transfers sheet, and that you didn’t rename it.
FYI … My message was: "Error: Broken data validation references in column G must be repaired… " The Column G was titled STATEMENTS in the TRANSACTION sheet. Began using @Jpfieber 's Account Reconciliation sheet, so I deleted the Statements Sheet. This was my first update since that happened, so the link to TillerHQ above helped resolve this quickly (ie., explaining how that Column gets added when you add that solution).
Simply deleted the Statements column G and Update refreshed.
Hi I’m a newbie and am experiencing this same error.
I followed your solution (nicely done! very clear) and this is what I found for my Criteria range: Data validation rules Value contains one from range D2:D701 Value contains one from range H2:H701
I don’t believe I have a Linked Transfers sheet (I didn’t add one and my Foundation Template is from the end of July 2024)
Should I change my criteria range to your recommendation: =‘Linked Transfers’!$O$2:$O
and if so how do I do that?
One more thing I’d like to add, I didn’t have this problem until I ported over one or two community sheets - the only one I kept is the “Category Tracker”. Could my experimentation with community sheets have accidentally caused the problem?
Thank you in advance for your assistance and help. Laurel
Aha! I solved it! I deleted the column H ‘Linked Transfers’ because last night I deleted the ‘linked transfers sheet’ that originally installed column H. So problem solved!! Yay!