Referencing a column and concatenate

Benjamin Brunnette · 12/09/20

Hello community,

I'm going to do my best to explain the formula I'm trying to create... I hope the picture helps clarify my explanation.

Here's essentially what I'm trying to do:

For every value in column D that equals A1, concatenate only those corresponding values in column E into B1

Thank you for your help!

Leibel S · 12/09/20

Use a join and collect combo.

See below example. Replace the bolded areas with your column names in smartsheet

=JOIN(COLLECT(e:e, d:d, a@row), CHAR(10))

Benjamin Brunnette · 12/09/20

To clarify - my image attached is from an excel grid simply for ease of viewing. Columns A+B and D+F are meant to represent two separate sheets.

Sorry for any confusion!

Leibel S · 12/09/20

Use a join and collect combo.

See below example. Replace the bolded areas with your column names in smartsheet

=JOIN(COLLECT(e:e, d:d, a@row), CHAR(10))

Best Answer