=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
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
