Check out this fun onEdit() counting you can do with checkboxes in a fun sheet with 1 Million Checkboxes.Anyone can log into google sheets and go here: https://bettersheets.co/checkboxes
3 add-ons you can install right now and your Google Sheets life is better!Tiny Sheets makes it simple to delete excess blank rows and columns.Sheet Styles makes for less headaches and better text colors.Button Styles makes awesome buttons for your users to click.
Find out in this quick experiment if a tab name can be alerted to the owner of the spreadsheet. Great for owners and operators who want to know if someone is changing the sheet.
I'll show you how to get text from one spreadsheet file to another with Apps Script. Yes you can do this by Importrange() but you might want another way to do it.
Count the number of cells or rows in a merged cell. This is a quick little code you can add to your sheets with the onOpen code.
How to sync different sections on different tabs. In this case we're taking data from multiple tabs putting into one, and syncing between those.
Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.
Automate the apps script we just created that moves blank rows from one sheet to the other sheet. Original tutorial to write the apps script
Apps Script function to move all blank rows if a certain column is not filled in. Learn how to automate this script →Here
There's something wrong with PROPER() the google sheets function. Let's fix it by customizing our own TitleCase() function inside of Apps Script.
Step by step tutorial to update random quote site to show both Quote and Author separately. Example site: https://todayquote.carrd.co/Quick tutorial to show you how to build a random quote site →Here
Automatically create a timestamp when a certain cell is marked as Done. I show you how to customize this scrip and where to get the script. I hope this is simple enough for beginners to start automating you sheets. If you want to see more automations and dive deeper into apps script enroll in Spreadsheet Automation 101and see more examples of Apps Script at BetterSheets.co/snippets