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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!