Today I noticed that my spreadsheets are no longer collecting data from Transactions:
What happened and how do I fix this?
Today I noticed that my spreadsheets are no longer collecting data from Transactions:
What happened and how do I fix this?
Strange.
Are you data feeds still piping into the Transactions
sheet?
Is it possible you renamed your Transactions
sheet or deleted/renamed a key column? Even an extra space at the end or beginning of the sheet name or column name will cause the other spreadsheets not to recognize critical data… so check for extra spaces in the sheet name & column names.
I don’t know what happened. But I was able to fix the issue by restoring the whole google sheet into an older version. Thanks!
Glad you figured it out. My guess is that you accidentally renamed the Transactions
sheet or a critical column in that sheet like Date
or Amount
.