3/9/2024 0 Comments Zapier airtable google sheets![]() If your spreadsheet has 10 million cells, you no longer need a spreadsheet. I'm going to say this out of love: if this is you, stop using Google Sheets. What you should actually do if you need 10 million cells I'm not sure who Google actually changed the limit for, but whoever they are, they should follow the next step. If it's not obvious yet, the actually practical uses for 10 million cells are few and far between. ![]() Making the cells as tall and wide as possible ( 2000 pixels), have a spreadsheet that could fill around 20 billion 4K TVs Take a census of all of the swans in England ( a real thing) for the next ~75 – 150 years Keep a record of the first and last name of every person in Cape Town, South Africa Watch a rabbit "walk" 158 miles over the next 19 years In my initial experiments, I was able to come up with a couple:Ĭreate a habit tracker for the next 27,397 years If you can get past the slowness, this new limit does open up some fun and interesting possibilities. (If you really do need that many cells, keep reading for some solutions!) 4. So the moral of this story is to resist the temptation of 10 million cells. If your sheet has lots of formulas, especially with slower functions like QUERY() or IMPORTRANGE(), that number is even lower. With even my relatively simple spreadsheet (which uses one formula in cell A2 to fill in the row numbers), timeouts start to happen at around 1,200,000 cells, almost one-tenth of the new limit. If Google Sheets can't form a response within that 30 seconds, Zapier receives a " timeout" error, meaning it may not receive new rows or make updates as expected. Adding a single SEQUENCE() function to count the cells resulted in a long delay, followed by my browser crashing. If you want to actually do anything to those cells, that's another matter entirely. Ten million of anything is a lot to process, so even things like scrolling will take longer than you might be used to. Once you've hit 10 million cells, you'll probably say two things:īecause even if they're blank, Google Sheets still has to think about all of those cells, and in turn, your browser still has to do work to render them. A sheet with 10 million cells is really slow You can still add up to five million rows at once, however, and if your sheet has more than two columns, you may need to do a bit of math to see how many rows you can add before reaching the barrier (10,000,000 divided by number of columns, rounded down). Tried to record a video of myself scrolling to the bottom with just a trackpad, but i have things to do this week /OAEKyusR07- Tyler Robertson March 7, 2022
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |