=JOINARRAY([End Delimiter],Range 1, [Range 1 Delimiter],...) *No delimiter for last range listed.
=JOINARRAY(", ", A:A, " ", B:B)
x 1, y 2, z 3
blank values are ignored, hence the over-ride for the end of the item delimiter
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
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
Hi It would be really helpful if we introduced a function capable of validating complex patterns of characters, numbers, and symbols in the given cell --in a predefined manner! Let's assume, the supplier-IDs in a business follow a universal/standard naming convention such as "SUPP001DEL2324 H", "SUPP002DEL2324-M",…
I must dynamically provision contact group memberships from dynamic groups in Azure AD based on departments or projects. I usually use SCIM to map AAD groups to application groups in other enterprise applications. I don't see this ability in Smartsheet and would like to request this as a new feature. I would also be happy…
Hi On a mobile device, the view options of Smartsheet Reports should be the same as those given in the view options given in the Sheets. Viewing the Reports at present is very inconvenient, in the absence of these View options (found in the Sheets). Please see the screenshots below for reference. Report View options (on a…
©2023. All Rights Reserved Smartsheet Inc.