Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Different concatenate results if cell contains a specific character

Topic Labels: Formulas
1192 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanel_C2019
4 - Data Explorer
4 - Data Explorer

Perhaps I’m not searching correctly, but I’m hoping the community can help.

I’m looking to have a formula that concatenates multiple columns based on whether or not one cell contains a specific character, such as a question mark ?, but also contains other text.

My formula already has a nested IF that is based on whether or not another cell is blank; see below:

IF({UTM Content}="","",CONCATENATE({Link To},“string”,{UTM Content}))

So, I want 2 results:
If cell {Link To} contains a ? somewhere in it, then I want “string”
If cell {Link To} does not contain a ? somewhere in it, then I want “string2”

Appreciate any help!

1 Reply 1

Hi @Chanel_C2019 - if I understand correctly, what I think you need is this:

Screenshot 2019-10-26 at 17.25.54.png

Rather than saying:

“If UTM content is empty, let the result be empty, otherwise…”

I would switch this around and say:

“IF UTM Content exists, then…, otherwise”

So in my example above, the formula field is:

IF(
  {UTM Content},
  IF(
    FIND('?', {Link To}),
    {Link To} & 'string' & {UTM Content},
    {Link To} & 'string2' & {UTM Content}
  )
)

As it stands the results look a bit strange, as I don’t know what “string” and “string2” should be, but hopefully this will give you enough to edit as you need.

JB