When opening Tiller on the Google Sheets App on your Iphone, does the spreadsheet sometimes show a day old version of the sheet and then freeze and crash? Then, if you open the Google Sheets app again, your Tiller data is up-to-date and it works fine.
This was happening to me for a long time. I finally figured out (I think) what is happening and figured out a way to fix it.
It seems the iOS App aggressively uses cached data. (Cached data is saved data from a prior visit.) This happens even if you have the Spreadsheet set to Available offline = Off.
What happens is the app first load the stale, older data. Then it tries to update all the new data and does a lot of recalculations, especially if you have a lot of sheets, transactions, and balance history. Often, this can cause the memory on the iPhone to spike and the display to freeze and crash.
The problem is not directly caused by Tiller or your Iphone. It is related to how the Google App and Google Sheets work.
Solution
I found a way to fix the problem.
Create a new Google Spreadsheet. Perhaps name it something like Tiller Mobile.
You should not link it to Tiller as one of your Tiller Sheets.
Use the IMPORTRANGE formula to import selected information from your original Tiller spreadsheet to your new Tiller Mobile-friendly spreadsheet.
You don’t want to import everything because then you might have the same problem. Just select the key information you want to see on your phone.
Perhaps you want to see your last 30 Transactions. You can use a formula like this in cell A1.
=IMPORTRANGE("ADD YOUR ORIGINAL GOOGLE SHEET URL HERE","Transactions!A1:I31")
In this example, by using A1:I31, I imported the header row and the first 30 rows of the Transactions sheet from column A to column I. You don’t need to import all your Transaction columns or rows.
You should remove all the unused columns and rows in the new spreadsheet.
You can do the same for any of your sheets. Just change the 2nd value in the formula from Transactions to the sheet you want to see and add the range you want.
Note that you won’t be able to edit the new sheet. It’s just a View of your original sheet.
I’ve imported 3 of my key sheets and I’ve had no issues with dated information or a frozen spreadsheet. This method shouldn’t cause any performance issues with your original sheet either.
In one of the cells, i added the formula =NOW() to get the current date and time. I formatted the number using Date Time. Now, i can see the time the sheet is updated and confirm it is using fresh data.
Here’s Google documentation on using IMPORTRANGE:
Give it a try and let us know if it solves the old data then crashing problem.
This issue was reported in an earlier Community post. I’m pretty sure it’s the same issue.