2

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.

From booleans to checkboxes

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.

(this question was also asked in a comment to https://webapps.stackexchange.com/a/116342/183114)

2

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

enter image description here

4

I just found out that one way is the following:

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

Not very elegant but seems to do the job.

1

...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"))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.