IF CONTAINS and Concatenation returning a Zero for Some Multi Select Options

I have a multi select column for event type and I want a concatenation based on the selection.

The below works for the first two instances but then adds a zero in before the rest. Is there a way I can rewrite it so that the zero doesn't appear?

=IF(CONTAINS([EVENT CATEGORY]@row, "Breakfast"), [EVENT CATEGORY]@row + "_" + REGION@row + "_" + COUNTRY@row + "_" + "\"" + [Hotel]@row + "\"") + IF(CONTAINS([EVENT CATEGORY]@row, "Lunch"), [EVENT CATEGORY]@row + "_" + REGION@row + "_" + COUNTRY@row + "_" + "\"" + [Restaurant]@row + "\"") + IF(CONTAINS([EVENT CATEGORY]@row, "Dinner"), [EVENT CATEGORY]@row + "_" + REGION@row + "_" + COUNTRY@row + "_" + "\"" + [Restaurant]@row + "\"") + IF(CONTAINS([EVENT CATEGORY]@row, "Dinner & Learn"), [EVENT CATEGORY]@row + "_" + REGION@row + "_" + COUNTRY@row + "_" + "\"" + [EVENT TITLE]@row + "\"") + IF(CONTAINS([EVENT CATEGORY]@row, "Full Day"), [EVENT CATEGORY]@row + "_" + REGION@row + "_" + COUNTRY@row + "_" + "\"" + [EVENT TITLE]@row + "\"")

Find more posts tagged with

Accepted answers

Paul Newcome

You need to output a "blank" in the third portion of each IF statement.

=IF(CONTAINS(.......), ......., "") + .......

All comments

Paul Newcome

You need to output a "blank" in the third portion of each IF statement.

=IF(CONTAINS(.......), ......., "") + .......

Samantha McDonald

Epic, thanks so much Paul!

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