How can I convert existing boolean cells into checkboxes in Google Sheets?

Question

I am using Google Sheets and I would like to convert some boolean columns (already filled with True/False values) into the "new" (launched April 2018) Tick box format.
This would be handy to update the values with a simple click/keypress.

However, I don't understand how to convert TRUE/FALSE cells into the Tick box format in bulk. I tried using copy/paste special of formats (from the tick boxes to the boolean cells), but to no avail.

user0 · Accepted Answer

right-click on the cell and select Data validation where:

user0 · Answer

...you can try something like this if you need the checkbox to be the return/result of formula evaluation:

=IF(A1=1;   
    IMAGE("https://i.imgur.com/DgTwvYi.png");
    IMAGE("https://i.imgur.com/8AxCgKZ.png"))

Davide Fiocco · Answer

I just found out that one way is the following:

Create a bunch of Tick boxes of the right size (desired rows x columns) using Insert > Tick Box after selecting the desired range
Copy the existing boolean values
"Paste special" them as values into the empty Tick boxes created at 1.

Not very elegant but seems to do the job.

How can I convert existing boolean cells into checkboxes in Google Sheets?

3 Answers

Add your own answers!

Ask a Question