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}))
解決済! 解決策の投稿を見る。
トピックはコミュニティのコンテンツの分類に役立ち、関連コンテンツを発見する可能性を広げます。
表示
返信
いいね!の合計
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!
表示
返信
いいね!の合計