JOIN function in a Sheet Summary

Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summary (or if I even can do this).

This is the function I'm currently using in a column titled Milestone Complete: =JOIN([Milestones completed]@row:[Count of Milestones]@row, " of ")

Is there another (better) way to do this in Sheet Summary?

Find more posts tagged with

Sheets

Formulas

Sheet Summary

Accepted answers

Paul Newcome

You have to "add" sheet summary fields together.

=[Field 1]# + " of " + [Field 2]#

This can also be done in the sheet if the columns you wnat to string together are not right next to each other for the JOIN function to work.

All comments

Paul Newcome

You have to "add" sheet summary fields together.

=[Field 1]# + " of " + [Field 2]#

This can also be done in the sheet if the columns you wnat to string together are not right next to each other for the JOIN function to work.

Mariann Carmen

Thank you Paul Newcome!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.