How can a checkbox append a value to another cell?

anotherjoe · February 12, 2021, 1:47pm

Screen Shot 2021-02-12 at 08.44.03.png
In this example if Cat and Mouse where checked, I would want to append those values to cell E1 and remove them if unchecked while leaving "Checked: " in the cell

JohnSUN · February 12, 2021, 2:19pm

First set “Linked cell” for each checkbox

Then use formula

{=TEXTJOIN(", ";1;IF(<range of checkbox values>;<range of texts>;""))}

This is an array formula, it should be entered with the Ctrl + Shift + Enter keys.

See example - CheckedValues.ods