How to JOIN multiple columns without delimiters

Here is my JOIN function used on Name, Start Time and Finish Time columns that works fine. However, I want to use it with IF empty show nothing (currently it shows the delimiters).

=JOIN(Performer1 + JOIN(": " + JOIN(Start1:Finish1, " - ")))

Any suggestion please?

Find more posts tagged with

Join

Accepted answers

All comments

KPH

You could use an IF AND or IF OR before the JOIN to only JOIN where at least one of the three columns is populated or where all are populated (therefore nothing will happen if all three (or any one, depending on how you get up the IF) are blank and there will be no delimiters).

Or, you could use IF for the string of delimiters instead of IF ISBLANK and return blank.

Danielle Arteaga

Assuming your set up looks something like this:

If you want the join only if Performer is not blank, try this formula in the Join column:

=IF(ISBLANK(Performer@row), "", JOIN(Performer@row + ":" + JOIN(Start@row:Finish@row, "-")))

The results would look like this:

Screenshot 2024-02-02 at 10.01.24 AM.png

If you want the join only if the Perfomer, Start AND Finish columns are populated, use this formula in the Join column:

=IF(OR(ISBLANK(Performer@row), ISBLANK(Start@row), ISBLANK(Finish@row)), "", JOIN(Performer@row + ":" + JOIN(Start@row:Finish@row, "-")))

Your results will look like this:

Screenshot 2024-02-02 at 10.02.49 AM.png

Rainfall

Thank you, everyone! That was perfect!

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, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.