JOIN function in a Sheet Summary

Mariann Carmen

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?

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.

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. 👍️