Readable guides for serious spreadsheet work

How to Add Star Ratings in Google Sheets: A Step-by-Step Guide

Have you ever wondered if you could add star ratings in Google Sheets? Well, the answer is yes! TL;DR * You can add star ratings in Google Sheets using data validation and emojis, creating an engaging rating system for surveys and feedback forms. * The process involves creating a range of star emojis, setting up a dropdown menu for selection, and using Google Sheets Formulas to convert emojis to numeric values for calculations. * Once numeric values are established, you can easily calcul...

Aug 14, 2024

10 Simple Ways to Make Your Spreadsheets Better

Here's a few things you can do very simply and in no time at all, to make your spreadsheets better. Make better spreadsheets for you to spend time in. And better for other people who have to use your spreadsheets.

Jul 31, 2024

How to Gain Confidence in Google Sheets

Building confidence in Google Sheets, and yourself is essential. It's benefits include: streamlining your workflow, ensuring data accuracy, and maximizing your productivity. If you’ve ever felt overwhelmed or unsure about using Google Sheets, this guide is here to help. Let’s explore some practical tips and strategies to boost your confidence and become a Google Sheets pro. I'll show you where you can find help inside and outside of Google Sheets. 👍Better Sheets Members can email me anytim...

Jul 29, 2024

How To Hide Data with Checkboxes in Google Sheets

Checkboxes in Google Sheets are a game-changer. They add interactivity, flexibility, and functionality to your spreadsheets, making data management easier and more enjoyable.

Jul 26, 2024

Capitalize All Words or No Words in Google Sheets

When working with Google Sheets, you might find yourself needing to adjust the capitalization of text within your cells, whether that means capitalizing each word or making everything lowercase. Here’s a quick guide to help you master these formatting techniques. Capitalizing All Words If you want to capitalize each word within a cell, you can use the `PROPER` function. This function will convert the first letter of each word in the specified cell to uppercase. Here’s how: 1. Click on th...

Jul 24, 2024

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 beyond simple check marks and emojis, enabling you to create dynamic and flexible approval systems. Introduction to Checkboxes Checkboxes in Google Sheets offer a cleaner and more efficient way to ...

Jul 22, 2024

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!

Jul 19, 2024

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 or deleting columns, changing the format, or adding tabs. In particular, one of our community members recently asked, “Can I get alerted when a tab name is changed?” To be honest, I didn’t know the answer...

Jul 17, 2024

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 times. Depends on your use of AI. I just updated Better Sheets' AI apps script to use Open AI Omni. Get the full script here. Can I use ChatGPT in Google Sheets? No but you can create ChatGPT in Google Sheets. Let me show you! But I need help with Google...

Jul 16, 2024

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 to handle this—automation! Manual versus Semi-Automatic Deletion You may know that you can manually delete rows in Google Sheets by right-clicking and selecting "Delete row." You can even select multiple rows...

Jul 16, 2024

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 number of values in column B that are between 1 and 16?” 1. Using COUNT. Using the COUNT function will count the  numbers in the range. 2. Using COUNTIF. Someone suggested using COUNTIF, however, we have to add a criteria (like >0). But what if we want to count numbe...

Jul 15, 2024

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? Two Ways to Use Equal and Two Ways to Use Not Equal We will explore four methods to compare cells: two for checking equality and two for checking inequality. Checking for Equality Method 1: Using the Equal S...

Jul 10, 2024