Google Sheets – How to Link Checkbox Values

data validationformulasgoogle sheets

I am using the checkbox feature in Google Sheets and I have another checkbox that I would like to be ticked when the original one is ticked.

I tried using the formula where the original checkbox is A1 and the secondary checkbox is B4 I would enter the formula =A1 in the B4 formula field, however, this just inserts the value true not a ticked checkbox.

Best Answer

This can't be done via "standard" means. Formulas are not permitted as custom checked/unchecked values.

here is one of many methods of how to fake it:

  • decide on cell height / width / color / background color
  • insert checkbox
  • zoom in via browser zoom CTRL + +
  • take a screenshot (ticked and unticked)
  • photoshop it (count for the frame around checkbox)
  • upload it (preferably on your Google Drive to minimalize update lag response)
  • and then use a simple IF statement to insert those images based on another checkbox

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