TIKTOK EDITS MY GOOGLE SHEET

0:00 Do you like checkboxes as much as I do? Checkboxes in Google Sheets, I love them. I just use them for all kinds of things, including automations. In this video, I'm gonna show you a crazy thing I've done. I've put as many checkboxes as I think I could inside of a Google Sheet. You probably have, like, columns of checkboxes. You might have done, like, a few thousand rows. This is a million checkboxes. Check it out You've probably never seen a sheet like this. This is actually being edited by anyone and everyone inside the sheet now. It is shareable. It is shared to anyone with the link as an editor . This is an experiment in letting anyone edit the sheet ever, and then so many things have happened. People are asking to be the editor . I'm gonna cancel that 'cause anyone can be the editor . You don't have to request access . One Million Checkboxes How To Hide Data with Checkboxes in Google Sheets One Million Checkboxes Track Anything! In a Google Sheet

0:45 Here's an anonymous alligator. Here's an anonymous hamster. They're actually inside. This is going viral a little bit on TikTok right now. Uh, and so go check it out. I wanna show you the version history 'cause a lot has happened. Uh, let's see. The, the… So many people have edited this in the past week, it's been pretty crazy. I don't know if this is actually gonna load any changes, 'cause it is loading in a million cells and then a differential of another million cells . I don't know if this is actually gonna work. People have deleted the entire tab. Some people have changed the file name. I have a little script that will update it and refresh it. , This is not loading at all. I think I have found a limit of Google Sheets where we have a Sheet Stories / Video Notes + Clear 24 Hour Old Videos Google Sheets Interface Changes How to See Version History in Google Sheets

1:31 million, uh, cells , there's a performance issue around five million. But in actuality, in, in using Google Sheets for the last 10 years, I find actually around two million is performance issues. But a couple things that will change your Sheets performance is having a bunch of, conditional formatting . If you have things executing on every edit across thousands or hundreds of thousands of rows and cells , you're going to have issues Look, people are editing it c- exactly right at this moment. They're trying to write some messages. But if you go to Extensions, if you actually get it open, you'll see a couple of scripts there. One is that it's counting every time you check off a checkbox up in the A1, it's One Million Checkboxes Upsides and Downsides of Google Sheets Conditional Formatting One Million Checkboxes Why Spreadsheets are Spreadsheets

2:16 gonna be counting how many are checked. That's like a fun little thing, but it's also showing you this performance, right, across multiple people doing multiple things over millions of cells . We actually have some real performance degradation. I think this is a very interesting experiment, even if it goes completely wrong go check it out right now. See what it's like for you for one million checkboxes . It's at bettersheets.co/checkboxes. You're watching Better Sheets here on YouTube. Watch this video or this video. It's gonna make your Google Sheets better Go ahead, ask me anything down below in the comments . And I'm going to answer it in a future video become a member of Better Sheets today. . You get videos, you get sheets. So what do I have to do to get you into a brand new Google Sheet? Go buy some tools that I've built inside of Google Sheets doing things in Google One Million Checkboxes How to Use Checkboxes for Approvals, and Change the Checkbox Text Track Anything! In a Google Sheet How To Count Checkboxes In Google Sheets

3:03 Sheets you never thought possible. Go check it out Announcing OnlySheets Great Sheets! Seedtable Created an amazing Community Board SHEETS and SHEET NEW FORMULAS in Google Sheets