Topics → Google Sheets Checkbox

Includes

14 Tutorials

Master the Magic of Google Sheet Checkboxes: A Comprehensive Series of tutorials

Become a Checklist Savant!

Dive deep into the realm of Google Sheet Checkboxes with our extensive tutorial series at Better Sheets! 

Explore the power and versatility of checkboxes through engaging and informative video tutorials designed for beginners, intermediates, and advanced users.

1. Magical Checklists That Archive Done Items (Intermediate)
Unlock the secrets of creating dynamic to-do lists that automatically archive completed tasks. Learn to enhance your productivity and motivation by leveraging Google Sheets' "on edit" function with the magic of checkboxes.

2. Creating a Random Motivational Quote Checklist (Beginner)
Embark on a journey to create a motivational quote checklist that inspires you with every task completion. Delve into the basics and craft a formula that generates random motivational quotes, elevating your daily routine.

3. Ultimate Checklist in Google Sheets (Beginner)
Discover the art of creating visually appealing checklists using checkboxes, headers, and conditional formatting. Customize your checklists, add progress bars, and incorporate fun elements, transforming ordinary lists into extraordinary tools.

4. User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdowns! (Beginner)
Simplify your data management process by mastering the art of filtering Google Sheet databases with dates, checkboxes, and dropdowns. Streamline your workflow, locate information swiftly, and enhance your overall efficiency.

5. Magical Things You Can Do with Checkboxes in Google Sheets (Beginner)
Unleash the potential of interactive checkboxes, transforming your sheets into dynamic web apps. Elevate your user experience, enhance interactivity, and boost productivity using creative data validation techniques.

6. Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes (Intermediate)
Explore the intricacies of the IF formula, understanding its nuances in conjunction with checkboxes. Automate your processes, improve decision-making, and harness the power of data validation for advanced applications.

7. Add a Checkbox to Turn on Dark Mode (Beginner)
Revolutionize your Google Sheets experience with a simple dark mode toggle. Master conditional formatting and custom formulas to switch between light and dark themes effortlessly, adding a touch of style to your spreadsheets.

8. 6 Ways to Make Your Checkboxes Better (Beginner)
Elevate your organizational skills by exploring creative ways to use checkboxes effectively. Uncover innovative techniques to enhance your productivity, streamline tasks, and bring your Google Sheets to the next level.

9. Create a Radio Button From Checkboxes Using Google Apps Script (Advanced)
Take your skills to the pinnacle by delving into Google Apps Script. Learn to code a radio button that controls multiple checkboxes, enabling advanced data validation and manipulation for sophisticated applications.

Join us on this educational journey to master the art of Google Sheet Checkboxes.
 
Whether you're a beginner seeking fundamental knowledge or an advanced user aiming for intricate automation, our tutorials cater to all skill levels. 

Boost your efficiency, creativity, and productivity with Better Sheets today! 🚀

14 Tutorials

Magical Checklists That Archive Done Items

Magical Checklists That Archive Done Items

 I'm sharing a magical checklist that will make your sheets so darn amazing. We'll start with a to-do list on a Monday and check off tasks to see them move to a "done" list. I'll guide you through the process of creating an "on edit" function in Google Sheets using app scripts. By the end, you'll know how to archive completed tasks from your to-do list. Get ready to boost your productivity and stay motivated! 🚀
Creating a Random Motivational Quote Checklist

Creating a Random Motivational Quote Checklist

I'll show you how to create a motivational quote checklist that generates a random quote every time you check off a task. We'll start from scratch and create a formula that displays motivational quotes from a list of 100 quotes. The quotes can be easily expanded, and the checklist will update accordingly. This tool will add a touch of motivation and productivity to your day. Enjoy!
COUNTA() RANDBETWEEN() INDEX()
Everything I know about Checkboxes (Cool Hacks)

Everything I know about Checkboxes (Cool Hacks)

Let me tell about some cool hacks you can do with checkboxes. Like making a checkbox have alternative values, or making a checkbox look like a button, not a check mark.
Uncheck Every Checkbox in Google Sheets

Uncheck Every Checkbox in Google Sheets

Automatically uncheck a whole range of checkboxes. Or just do it yourself with the spacebar.
Laziest Checklist Ever

Laziest Checklist Ever

Get your spreadsheet to check off your checklist for you.

Dive into spreadsheet automation with this easy to follow script, or copy the sheet and use the script as you wish.
Ultimate Checklist in Google Sheets

Ultimate Checklist in Google Sheets

how to create and customize checklists using Google Sheets. I show you how to add check boxes, headers, and formatting to make your checklists visually appealing. I also explain how to use conditional formatting to create a progress bar and add fun elements like easter eggs. Watch this video to learn how to make the ultimate checklist and feel free to suggest more features for future videos!
IF() SPARKLINE() COUNTIF() COUNTA()
User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

Search through and filter data to get what you want, when you want it. Tired of sifting through endless rows and columns? Learn how to filter your Google Sheet database with dates, checkboxes, and dropdowns. Simplify your workflow today!
IF() FILTER()
Magical Things You Can do with Checkboxes in Google Sheets

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sheets' UI better with more interaction.
Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes

Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes

Let’s talk about the IF formula and the differences. Learn how to insert a checkbox and all the other things it can do for you.
IF()
Add a Checkbox to Turn on Dark Mode

Add a Checkbox to Turn on Dark Mode

Get ready to shake things up, formula fanatics! Learn how to add a dark mode button to your Google Sheets with this dead simple trick. Using conditional formatting and a custom formula, you can turn on dark mode with just one click. Don't miss out on this cool feature! Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting
Access Free API's with Google Sheets

Access Free API's with Google Sheets

Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with API's in this 1 hour dive into Free APis available online and accessible in Google Sheets. 
API's here: freepublicapis.com
IF() ISBLANK() IMAGE() COUNTIF()
6 Ways to Make Your Checkboxes Better

6 Ways to Make Your Checkboxes Better

Learn How to Take Your Google Sheets Checkbox to the Next Level and Get More Organized! Click Now to Discover Creative Ways to Use Checkboxes and Boost Your Productivity!

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.
Study Better With Google Sheets

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.
VLOOKUP() GOOGLETRANSLATE() INDEX() RANDBETWEEN() COUNTA()
Create a Radio Button From Checkboxes Using Google Apps Script

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.
OR() NOT() IFS()