Tag: data validation

The Complete Guide to Smart Chips in Google Sheets

Smart Chips in Google Sheets allow us to add richer information to our Sheets, beyond the standard data contained in cells. They help us work more seamlessly by bringing information from external sources into our Sheets.

In this post and video, we take a comprehensive look at the smart chip feature. You’ll learn what they are, how to work with them, and see some example workflows to understand how they can enrich your Google Sheets workflows.

Table of Contents

Continue reading The Complete Guide to Smart Chips in Google Sheets

How To Create A Google Sheets Drop-Down Menu

In this post, we’ll look at how to create a Google Sheets Drop-Down Menu. Here’s an example of a drop-down menu to record the status of deals in a real estate deal pipeline:

Google Sheets Drop-Down Chips

Drop-down menus are great for data entry and making your Sheets dynamic.

In this post, we’ll explore both of these techniques with examples.

But first, let’s see how to create a Google Sheets drop-down menu.

Continue reading How To Create A Google Sheets Drop-Down Menu

Making Google Sheets look less like… Google Sheets

This is a guest post from Josh Cottrell-Schloemer.

Google Sheets is an incredibly powerful spreadsheet tool for pulling, processing, and presenting data. But many people don’t realize that you can also use it to build interactive dashboards.

With a bit of creativity we can go from this:

Dashboard Data Table in Google Sheets

To this:

Google Sheets Dashboard

The skills to build this type of dashboard aren’t difficult to learn and you can get started with a basic knowledge of Google Sheets.

Here’s a walkthrough of the dashboard shown above:


Continue reading Making Google Sheets look less like… Google Sheets

How To Mimic Radio Buttons With Formulas and Checkboxes

In this post, we’ll look at how to mimic radio buttons with formulas and checkboxes in Google Sheets.

Radio button behavior with checkboxes and formulas

This formula method has one limitation: you have to uncheck the current selection before you can check a different one.

With true radio buttons, when you click any button it will unselect the other one for you. You don’t have to do the extra step of manually unselecting it first.

For that reason, I recommend using an Apps Script method to create true radio buttons in Google Sheets.

However, the formula method presented in this post is useful if you don’t have access to Apps Script or simply don’t want to add code to your project.

Continue reading How To Mimic Radio Buttons With Formulas and Checkboxes

How To Create A Select All Checkbox in Google Sheets

In this post, you’ll learn how to create a Select All checkbox in Google Sheets, as shown in this image:

select All Checkbox in Google Sheets

But before we look at that, did you know there’s already a quick way of selecting all checkboxes manually?

Continue reading How To Create A Select All Checkbox in Google Sheets