Checkboxes. Simple? Let's up the ante!
This video will take you on a journey to master conditional formatting, uncover handy tips and tricks, and even show you how to use Google Apps Script to send emails directly from your Google Sheet! Perfect for beginners and seasoned users alike, this tutorial will level up your productivity game.
After you watch these videos, just start playing in your spreadsheets. If you still want to improve, make sure you subscribe for more juicy tips and tricks.
LINKS
Thanks to Ben L Collins for the radio buttons work. If you don't know him yet, you will as soon as you start searching for Google Sheets solutions online. His library is HUGE: https://www.benlcollins.com
This is the spreadsheet for most of the things you've seen in this video:
https://docs.google.com/spreadsheets/...
And if you want the script to the emails tip, check out this Google Sheet that contains the Script: https://docs.google.com/spreadsheets/...
⏳ TIMESTAMPS
0:00 Intro
0:10 Basic conditional formatting
1:10 Checkbox validation
2:18 Ondemand checkboxes
3:30 How to block the Heads Up error
4:45 Roll a dice with LAMBDAs
6:40 How to create static timestamps
7:28 Using checkboxes as formula loaders
9:01 Dynamic graphs
10:59 Create a Select All button
13:26 Simulating Radio Buttons
14:28 How to send emails directly from Google Sheet
GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓