Convert TRUE or FALSE to Checkboxes in Google Sheets

Published on

You can convert Boolean TRUE or FALSE values to Checkboxes (Tick Boxes) in Google Sheets, but not text values.

Boolean values are logical values that are either TRUE or FALSE. You can easily identify them using the ISLOGICAL function in Google Sheets.

For example, if the value to evaluate is in cell A2, you can try =ISLOGICAL(A2). If the formula returns TRUE, it means the value in cell A2 is a Boolean TRUE or FALSE value.

Here’s how to convert TRUE or FALSE values to checkboxes:

Convert Manually Entered TRUE or FALSE Values to Interactive Checkboxes

It’s very easy and quick to convert a column with Boolean TRUE or FALSE values to checkboxes.

Simply select the cells, go to the Insert menu, and click on Tick Box. This will turn TRUE into checked boxes and FALSE into unchecked boxes.

Convert manually entered TRUE or FALSE values to interactive checkboxes

They will maintain their interactive nature, meaning you can click the checkboxes.

Convert Boolean TRUE/FALSE Formula Outputs to Checkboxes (Non-Interactive)

When performing comparisons using operators or functions such as AND, OR, NOT, XOR, etc., the output will typically be Boolean values. You can display them as checkboxes, but they will not be interactive.

I have a list of numbers in cells A2:A8. I’ve inserted the following formula in cell B2 and dragged the fill handle down to B8:

=A2>50

This formula returns Boolean values.

Formula returns Boolean values

You can select these outputs and apply the Insert > Tick box.

Another option is to first insert Tick boxes in cells B2:B8, then enter the formula in cell B2 and drag the fill handle down.

Convert formula outputs to checkboxes in Google Sheets (non-interactive)

Again, note that the Tick boxes will not be interactive, meaning they won’t respond to toggling.

Additional Tip

Here, I’ll show you how to compare two columns and convert matches or mismatches to checkboxes in Google Sheets.

In the example below, I am checking the availability of names in column A within column B. If a name is found, I want to mark the corresponding checkbox accordingly.

The range for List 1 is A2:A, and for List 2, it’s B2:B.

Steps:

  1. Insert checkboxes in cells C2:C.
  2. Use the following formula in cell C2 and drag it down:
=NOT(NOT(IFNA(MATCH(A2, $B$2:$B, 0))))

This formula will toggle the checkboxes based on whether there is a match between columns A and B.

Resources

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Hierarchical Numbering Sequences in Excel

Creating hierarchical numbering sequences in an Excel spreadsheet can significantly improve the way you...

How to Easily Repeat a Sequence of Numbers in Excel

Excel offers multiple ways to accomplish tasks, and the simplicity of each approach depends...

Create a Sequence of Dates at Every Nth Row in Excel (Dynamic Array)

Would you like to create a sequence of dates in every nth row in...

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.