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.
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.
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.
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:
- Insert checkboxes in cells C2:C.
- 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
- Assign Values to Tick Box and Total It in Google Sheets
- Change the Tick Box Color While Toggling in Google Sheets
- 10 Best Tick Box Tips and Tricks in Google Sheets
- Check-Uncheck a Tick Box based on the Value of Another Cell
- Tick Mark: Lock and Unlock Cells Using Checkboxes in Google Sheets
- Highlighting Multiple Groups and Control Tick Boxes in Google Sheets
- Create a List from Multiple Column Checked Tick Boxes in Google Sheets
- Vlookup in Checkbox Checked Rows in Google Sheets