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

Samantha McDonald

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 + "\"")

Paul Newcome

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

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

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