I need help Join/Collecting Rows
So I have an issue with Smartsheet formulas where I am unable to write the formula to join rows. So, if the "left_company" Column values are equal, then join/append the "Timeline Date" values so that the output is showed on the "Timeline" Column. Do not populate the "Timeline" Column if there is already one for the same "left_company" value
Answers
-
Try this:
=JOIN(COLLECT([Timeline Date]:[Timeline Date], [left_company]:[left_company], @cell = [left_company]@row), "delimiter of choice")
-
Hi Paul!
That worked wonders! Do you think it is possible to not have duplicate entries?
Like if we already have a value for the first 10x Genomics the second wont have a value in the Timeline column?
-
You would need to insert an Auto-number type column with no special formatting (called "Auto" in this example) and then use something like this:
=IF(COUNTIFS(Company:Company, @cell = Company@row, Auto:Auto, @cell<= Auto@row) = 1, JOIN(COLLECT(..........)))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!