Well, Google Chrome & Sheets take a lot of CPU & RAM from your computer.
I have a sheet that doesn’t feed into AppSheets directly, but it feeds into several places, has 5,000 rows and 30 columns. About 20 columns have complex formulas and conditional formatting.
It loads fairly quickly. About 2 seconds. Which is not quick compared to a regular sheet at 0.5 seconds, but still… Quick.
So, if over a year your sheet produces 12,000 rows and 10 (?) columns, you might be fine.
For Google Sheets.
But, for AppSheet, I don’t necessarily understand what forces play into the sync time.
There are different options for sync levels, and some options inhibit the app such as delayed sync or sync only on edit, and sometimes AppSheet doesn’t recognize an edit if the edit was outside of AppSheet via an IMPORTRANGE() formula from Google Sheets…
For my app at least, it can range from 2~10 seconds for a sync, which seems pretty long for the modern user… I’m thinking of solutions for this.
LinkedIn
Twitter
