My transactions tab shows only columns A through F. The sheets works fine but I can not “find” the missing columns. The sheet has no filters or groups. A column inserted to the right is column G. What have I done?
Hmmm, I know you said there are no groups - so there’s no +/- group button above column F? 
What happens if you type G1 in the Name box (Ctrl+J)?
There is not a “+” on this sheet! I’m not sure what you are asking for the second part of the answer.
Typing G1 and Enter in the Name box is just a way to test if that cell actually exists on the sheet.
Checking your Version history to restore to a previous working version might be the way to go, but then of course you’ll lose any changes you’ve made since then. Data Fill should still work though from that point.
On January 30th, the missing columns were grouped, indicated by the + sign. I don’t know what’s happened with the + sign. The sheet has been working correctly so the columns must be present, right?
1 Like
Not necessarily. I believe the way that the Tiller fill works is that it will skip inserting any column data where the column is not present, instead of failing outright.
I would really try to make a duplicate of your current workbook to have a backup, then run the version history on your original workbook to see if you can get back to a point in time where they were present.
Nope, I tested it in a brand new spreadsheet just now.
Deleted all columns past the Amount column.
Linked one account.
Data happily filled without error messages (note that data filled all the way back to when I originally linked the account to Tiller, not just the typical 90 days for a new linked account).
At the moment, I’m thinking your columns got deleted.
I can see why you wouldn’t want to restore back to a January version, although you could test it by making a copy of the January version, link all your accounts, and then in theory Tiller has all that data to fill it to current. But, if you’ve done other customizations, including outside the Transactions sheet, or any changes to your linked accounts - those would need to be redone.
Or, maybe you could make a copy of the January good version and restore missing columns and some data in your latest spreadsheet based on that. You’d still have some empty fields for the newer transactions, which may not cause any issues for you, since you aren’t experiencing anything else amiss. And then going forward, new transactions would fill the restore columns.
1 Like
Thank you for your time. I don’t understand how an intricately linked spreadsheet can work with missing columns of data, but at this point, I don’t need to understand. Thanks again!
@rdc.tiller if the columns where deleted (and are in fact missing) it’s correct that Tiller Money Feeds will fill the data for the columns that are present in the sheet. The only required column is the Date column.
While the data will still fill in without those columns there you may notice some of the templates/dashboards don’t work properly without the other columns (e.g. some columns might rely on the Month column in addition to the Date column) and if we were to ever need to troubleshoot transaction related issues (like duplicates or incorrect data) we’d need the Transaction IDs.
So I would recommend either restoring to a previous version to make sure you have the columns you need or just start fresh in a new Foundation Template.
Thank you.
With some manual actions, the restored version is up and running.
Thank you and others for the support!
1 Like