Andrew Kamphey

Google Sheets wizard at BetterSheets.co

Advanced Checkbox Hacks for Streamlined Approvals

Advanced Checkbox Hacks for Streamlined Approvals

Google Sheets is a powerful tool that offers a wide range of functionalities. One such feature that can significantly enhance your workflow is the use of checkboxes for approvals. In this blog post, we will delve into some advanced checkbox hacks in Google Sheets. These tips will help you move

How to Customize PROPER Function in Google Sheets (Creating a Headline Case)

Have you ever wanted to make all the words in your Google Sheet stand out? Here is an easy tutorial for capitalizing each word, just like a title!

Can I get alerted when a tab name is changed?

Can I get alerted when a tab name is changed?

Use Apps Script to receive emails whenever there’s a change in your Google Sheet structure Are you an organization with multiple people working on the same Google Sheets file? Then, you might want to know when one of your people changes something in the spreadsheet, whether that be adding

Google Sheets AI Formula

Google Sheets AI Formula

Does Google Sheets have an AI Formula? No but you can add one. Simple use Apps Script to add an AI formula to your sheets. You can use your own AI from Open AI and this comes out to be much cheaper than even $20 a month for ChatGPT at

Automate Row Deletion in Google Sheets with Apps Script

Automate Row Deletion in Google Sheets with Apps Script

In this post, we'll cover how to remove rows automatically in Google Sheets using Apps Script, ensuring you save time and streamline your spreadsheet management. You're probably already familiar with the manual way of right-clicking and deleting rows, but there's a more efficient way

How to Count Between 1 and 16 in Google Sheets

How to Count Between 1 and 16 in Google Sheets

A question from the Facebook group "I Love Google Sheets" wants to know how to count numbers between 1 and 16 in a series. So let us break it down and look at the best way to do this. The question was "How can I count the

How to Tell if Two Cells are the Same or Not the Same in Google Sheets

How to Tell if Two Cells are the Same or Not the Same in Google Sheets

Determining whether two cells in Google Sheets are equal or not is a common task that can help streamline data analysis and ensure data accuracy. Open up your spreadsheet and follow along with this guide on how to do this using different methods. Are These Two Cells Equal or Not?

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons