Report Builder: Include and exclude on same column

Mark Lappegaard
Mark Lappegaard ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

In Report Builder for WHAT, I want to include one term but not another for a specific column.   (See attached.)

 

But the "Exclude selected items" check box is all or nothing.  

 

It can't be this hard. There has to be a "contains" and "does not contain" filter ability. 

 

To be clear, I want a result that will show all the primary tasks that contain the word "Assembly" but do not contain the word "Resource". 

 

What am I missing, please? :) 

Capture.PNG

Comments