Join/Collect? Formula to record text in a row on if a box is checked on sheet one ...

Debbie Petersen

I am trying to put a formula on Sheet 1 in Column 2 that references Sheet 2, column 2 (DBE)( checkbox) - if the box is checked on Sheet 2, The text from Column 1 (Vendor) will all populate with a comma between each on Column 2 on Sheet 1

SHEET 1

SHEET 2

Thank you! I'm stumped on this one!

Paul Newcome

Ok. In that case you would use something along the lines of

=JOIN(COLLECT({Column To Join}, {Checkbox Column}, @cell = 1), ", ")

Paul Newcome

Are you able to manually enter the outcome you are hoping to achieve and provide a screenshot of that?

Debbie Petersen

Sure!

SHEET1 Column 2

Sheet 2 Column 1 Column 2

Paul Newcome

Ok. In that case you would use something along the lines of

=JOIN(COLLECT({Column To Join}, {Checkbox Column}, @cell = 1), ", ")

Debbie Petersen

Bingo! I had missed a "

Thank you so much!!

Paul Newcome

Happy to help. 👍️