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
-
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))
Answers
-
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!
-
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))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!