Calculated field that uses an and statement between 2 fields.

Question

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}))

JustinRenteria2 · Accepted Answer

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})).......

kautuk_sahni · Answer

@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!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded