Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
=JOINARRAY([End Delimiter],Range 1, [Range 1 Delimiter],...) *No delimiter for last range listed.
=JOINARRAY(", ", A:A, " ", B:B)
results in:
x 1, y 2, z 3
blank values are ignored, hence the over-ride for the end of the item delimiter
@Paul Newcome
Curious about your thoughts on this one.
@L_123 I've seen this pop up quite a few times, and we always have to use a helper column in the source sheet to first join columns A and B together then bring everything over to the target sheet from the helper column.
@Paul Newcome Yes, it's solve-able with a helper, which is what i've had to do historically (sometimes multiple helpers)
I think modifiable arrays would be amazing, and this could just be the first step. imagine if you could modify a range with a collect formula prior to using the criteria, that would be another example that could be huge.
Added the collect idea :https://community.smartsheet.com/discussion/109279/collectmod-formula/p1?new=1
Sign in to comment or add your vote.
