Removing commas if a field being joined is blank?

Have a "Reason for DQ" field that aggregates responses from hidden helper columns (finds fields with "bad" conditional formatting).

What it looks like unhidden:

I'm so close...but so far...how do I keep the commas separating data but remove them if the fields are blank? Forumula being used below:

=JOIN([Pre-Bid helper]@row:[Crimes Helper]@row, ",")

Find more posts tagged with

Formulas

Accepted answers

parulmishra

Hi @MTaber

Try using this formula

=JOIN(COLLECT([Pre-Bid helper]@row:[Crimes Helper]@row, [Pre-Bid helper]@row:[Crimes Helper]@row, NOT(ISBLANK(@cell))), ", ")

All comments

parulmishra

Hi @MTaber

Try using this formula

=JOIN(COLLECT([Pre-Bid helper]@row:[Crimes Helper]@row, [Pre-Bid helper]@row:[Crimes Helper]@row, NOT(ISBLANK(@cell))), ", ")

MTaber

Worked beautifully, thanks @parulmishra

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.