I am "trying" to create a calculated field to concat fields based on multiselect fields. I can get my statement to work if there is just one criteria. but how do I/is it possible to get the and statement to work between 2 fields. I found some examples that are kind of looking like what I want, but when I try and add the && into the text the wheels fall off. Here is where I ended up around the time I was pulling my hair out. Any help would be greatly appreciated.
IF(CONTAINS("Meta (FB/IG)",{DE:GF Paid Media Type}&&”Static Image”,{DE:Duration}),CONCAT({DE:GF META Story Static Specs},"\u000A",{DE:GF Copy for TIKTOK ASSETS},"\u000A",{DE:GF Meta Copy Specs}))
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
The contains statement looks wrong to me for the simple fact that it looks like you're inputting 3 variables into a expression that only takes 2 variables.
I would personally structure it in the following way. I havent tested this though.
IF((CONTAINS("Meta (FB/IG)",{DE:GF Paid Media Type})) && (CONTAINS(”Static Image”,{DE:Duration})).......
The contains statement looks wrong to me for the simple fact that it looks like you're inputting 3 variables into a expression that only takes 2 variables.
I would personally structure it in the following way. I havent tested this though.
IF((CONTAINS("Meta (FB/IG)",{DE:GF Paid Media Type})) && (CONTAINS(”Static Image”,{DE:Duration})).......
edited my reply above to add a couple of parenthesis
@SethStaley Just checking in — were you able to resolve your issue?
We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!
Views
Replies
Total Likes
Views
Likes
Replies