Report Builder who criteria with multiple contacts
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.
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
