=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
Sign in to see the current vote count, add your own vote, or leave a comment.
@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
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
It would be useful if users who clicked a Dynamic View link (that they were not previously added to) could "request access" to the Dynamic View, and provide a reason, so that the admin can easily grant that access. The use case for me would be to avoid having to pre-populate and then maintain a user group of viewers, but…
As the smartsheet admin for Europe, it would be extremely helpful to be able to view all Automations / recurring emailed reports in one place as opposed to sheet level. It's almost impossible to ensure everything is working correctly / delete recurring emailed reports without this.
