Expand my Community achievements bar.

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.
SOLVED

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
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})).......

View solution in original post

3 Replies

Avatar

Correct answer by
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