Hey @GG1,
I did notice the larger document was quite slow to load. The issue with this one is the attachments. Data + Attachments in a single document are limited to 1GB but yours is at 1.3GB total. You can read about limits in Grist here: Limits - Grist Help Center
I see two attachment columns in your document. One is located in the tasks_daily table but only has two total image uploads, not causing any issues at this point. If you think this column will eventually contain many more images, I would recommend storing the image on some storage site like Google Photos or Imgur. You could include the image URL in a column and preview it easily using our Image Viewer custom widget.
The second attachment column is in the studies table and about 1500 rows have a PDF uploaded. I would recommend storing these PDFs elsewhere like Google Drive or Dropbox then include a link to the document in this column. We do have a Dropbox Embedder custom widget that may work nicely for this: Custom - Grist Help Center
The second document, Styles loaded quickly for me but I did see how a formula was taking 0.6 seconds. When you fix this, another one pops up. All of these had errors in the formulas which was causing the increase in calculation time. So there are a few different issues below to be resolved.
-
Fix the references in the to column of the Internal table that are giving errors. There are three. You can easily filter to these three records by filtering the column to only those with
#Invalid Referrors;
-
In the SEO table, the impact column contains conditional formatting that gives errors when there is no value in the impact column. Update these to begin with
$impact andso these conditions will be false if there is no value.
-
Update the conditional formulas in impact column of the SEO [by impact] summary table as well to include
$impact and
These three fixes will clear up the slower formula calculations for that document.
Let me know if you have any follow up questions.
Thanks,
Natalie