"contains" logic in Report Builder to include "and" instead of just "or"
I'm building a report using the "contains" logic on the Primary field called "Task Name". I'd like the report to return the rows whose Task Name includes the words "Phase" AND "Review". I cannot figure out how to execute this logic as it defaults to including rows whose Task Name include the words "Phase" OR "Review". This returns more rows than I want. Is there a way to do this? I do not have the ability to add columns to the targeted sheet in order to filter this down.
Answers
-
"And" is only allowed to add filters in your report between each column, not within the column, that is always "Or".
Another fun thing is you can only do all "And" with multiple columns and only all "Or" (that gray bar).
I direct you to another helper column with a formula that searches for the texts of "Phase" and "Review".
