jeudi 15 septembre 2022

In Google Sheets I am trying to put columns of text together into one cell, ignoring blank cells, with If statements

To begin, the spreadsheet is here.

I have "Sheet1" that has columns A-I titled with movie genres and descriptors below. On "Sheet2" I have each genre next to a checkbox. The end goal is to be able to select any and all of the genres that apply and have the descriptors put together into one cell (Sheet2!A5) separated by a comma. I want to include the entire column of each genre ignoring the blank cells so I can add and take away descriptors as needed without breaking anything.

Below is the expected result if all are selected enter image description here

I am very new to the world of functions and have spent hours at this point trying to browse all the forums and various how to videos, but I haven't been able to find anything close enough to work.

Below is what I tried. enter image description here

I have updated the permissions for anyone with the link to edit. Here is the link once more. Any help is GREATLY appreciated. Thank you in advance for your time and efforts. I know how important those are. : )




Aucun commentaire:

Enregistrer un commentaire