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

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!