Checkbox that references Array [calc]

[olp]

Hello,

I’d like to make a checkbox in my spreadsheet that references the state of an array, but doesn’t write to it as that would break the array formula.

The goal is to get the checkbox to edit the original data the array references, instead of the array’s cells. If the checkbox is just a reference that calls an event when clicked then I can make the click trigger an edit of the original data, which then updates the array, which then updates the appearance of the checkbox.

If there’s a better way of doing what I need then I’d be open to suggestions.

More info here

thanks,

[JohnSUN]

First, you are welcome! Second, please explain this part of the “to get the checkbox to edit the original data” question. And thirdly, if you are going to handle a checkbox status change event anyway, is it worth binding with the checkbox, perhaps it is easier to handle the array change status?