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!