Join collect order
Hmmm, not finding this and my experiements are not helping.
I have a join collect that returns the full set of data as expected, but it needs to be sorted in a particular order.
Thought it might be based on PRIMARY, but that's not it. Thought it might be an alphabetical return, that's not it either. Thought it might be based on where the row is sorted in the raw/source sheet, that's not it.
Eg strings:
1 - (abc) - text 1
2 - (xyz) - text 2
It returns though as
2 - (xyz) - text 2
1 - (abc) - text 1
Answers
-
I would need to see a specific example, but in general... JOIN(COLLECT()) will return values from left to right and then top to bottom. The below example would return 1,2,3,4,5
And this would return 1,6,2,7,3,8,4,9,5,10
-
Issue resolved. I have a lower level sheet with limited data. it rolls up to a 2nd order sheet with various combinations. Followed then by a third sheet with full set of combinations. Yes, complex. I was sorting only the lower sheet. When I sorted the 2nd order sheet, it flowed as expected on the join collect.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!