1

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.

  • can you provide a copy of your sheet? – user0 Jul 18 '18 at 11:55
  • Will you need that the "another checkbox" works as a checkbox or just that looks as a checkbox? – Rubén Jul 18 '18 at 14:09
1

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

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.