コミュニティアチーブメントバーを展開する。

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
解決済み

Calculated field that uses an and statement between 2 fields.

Avatar

Level 2

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

トピック

トピックはコミュニティのコンテンツの分類に役立ち、関連コンテンツを発見する可能性を広げます。

1 受け入れられたソリューション

Avatar

正解者
Level 6

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

元の投稿で解決策を見る

3 返信

Avatar

正解者
Level 6

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

Avatar

Level 6

edited my reply above to add a couple of parenthesis 

Avatar

Administrator

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



Kautuk Sahni