Expand my Community achievements bar.

SOLVED

Adding more than one namecontains rule to one line.

Avatar

Level 2

Hello,

 

I was curious if it is possible to add more than one "namecontains" rule to a filter int text mode. I know I can use OR to add a new set of rules but it would make my life easier if it were possible to add more than one contains rule.

 

For example. I am attempting to pull projects with "Red" in the name but also I want to find projects with "Blue" in the name. I would like to make one rule that says "Project with Red or Blue in the name pull in" rather than make two separate rules. Is this possible in text mode?

 

Thank you

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I'm thinking you might want this old trick published by Galen and more recently by Doug. (showing both since there are variations in syntax that might come in useful)

 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/filter-not-blank-and-not-x/m-p/...

 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/and-another-textmode-trick/td-p...

View solution in original post

2 Replies

Avatar

Level 10

Check out "IFIN". Explanation here: https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/calculated-custom-data/cal...

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

Avatar

Correct answer by
Community Advisor

I'm thinking you might want this old trick published by Galen and more recently by Doug. (showing both since there are variations in syntax that might come in useful)

 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/filter-not-blank-and-not-x/m-p/...

 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/and-another-textmode-trick/td-p...