Report Builder who criteria with multiple contacts

csherwin66446

I am building a report in SS and want to see the results for all projects that have both person A and person B assigned.  When I create my search criteria, I am selecting both person A and B from the list, however SS automatically shows it as:

Teams Impacted

     has Person A or

     has Person B

 

How can I change this to 'has person A AND has person B'?

 

Many thanks for your input - I am new to Smartsheet and couldn't find an answer in the help section or community.

Andrée Starå

Hi,

If you click on the OR bar it will change to AND.

I hope this helps you!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

csherwin66446

Hi Andree,

Thanks for your input.  When I click on the OR button it just changes the buttons between sections, but not the criteria within a section.  See screenshot below - I clicked the button that is circled and it now says AND, however the items highlighted still show OR.