Referencing a column and concatenate

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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!