Combining Cells - Check Box

Paula M.

Hi! I'm using a formula that works great for cells with text, dates, etc but I'm not sure how to edit it to account for check boxes. I have several columns that have check boxes. The formula is combining multiple rows in one sheet into another sheet. The check boxes may have 1 checked and 2-3 unchecked so it needs to be able to read if it contains true. Any help is appreciated!

=JOIN(COLLECT({New or Returning Intern}, {Intern Name (Non Dropdown)}, [Name Helper for Formula]@row))

kowal

hi @Paula M.,

It might "merge" the cells for your even the checkbox but if the checkbox is unchecked it will not bring any value.

Did you try to combine checkboxes when they are all checked?

Paula M.

It gives me "false" or "true" results but some may look like "false false false true" or some variation. I want to check the box if "true" is any part of the answer and leave it unchecked for only "false" results.