Text Join Formula

Brittanyy

Hi there,

I created this formula: =JOIN(Course@row) + " " + [Course Date]@row that worked

but I need assistance on changing the order of it.

Course Date with Parentheses around the date and Couse Name

Formula that I have: =JOIN(" ", "(" + [Course Date]@row + ")", [Course]@row) that will not work

Example what I want: (11/13/23) Introduction to Law

Find more posts tagged with

Formulas

Accepted answers

Matt Johnson

Hi @Brittanyy

I don't think you ever needed the JOIN part. Please try this one. I think it will work.

="("+[Course Date]@row+") "+[Course]@row)

I hope that helps.

Matt

All comments

Matt Johnson

Hi @Brittanyy

I don't think you ever needed the JOIN part. Please try this one. I think it will work.

="("+[Course Date]@row+") "+[Course]@row)

I hope that helps.

Matt

NickStaffordPM

To @Matt Johnson's point, the JOIN function is Throwing it off. If you remove it, it should be fine... Could you confirm for us? I am interested to know this solution

Brittanyy

@Matt Johnson and @NickStaffordPM

This formula worked without the Join.

="("+[Course Date]@row+") "+[Course]@row)

Thank you so much for the assistance.

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.