Report Filter Conundrum

holli.nunn
holli.nunn ✭✭✭
edited 09/07/23 in Smartsheet Basics

I want to filter out these parameters - A project has 'New Store Unchecked' and 'Survey Scope Unchecked'

The problem is that when a project has New Store Checked it will always have Survey Scope unchecked so I cant filter by 'Survey Scope Checked' as 'or' in the filter because I need to see those New Stores.

Is there anyway to get this to work?? Here's what my filters look like


Best Answer

  • Itai
    Itai ✭✭✭✭✭✭
    Answer ✓

    Hey @holli.nunn ,

    Have you considred having 2 groups of filters, similar to the one you did, with an OR on all of them?

    Itai Perez

    Reporting and Project Manager

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

Answers