Is there a way to use OR in a Dynamic View filter condition?

MikeChambers

In a View, I can create a custom filter that selects where the Project Lead is "Mike" but I want to also say "OR Debbie." Is that possible? It looks like I can only choose AND.

Andrée Starå

You are more than welcome!

Glad to hear that it worked for your present use-case.

✅Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Mike,

Unfortunately, it's not possible at the moment to change the AND to OR, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, in your example you could use the first condition and add Debbie because you're using the "has any of".

Would that work/help?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

MikeChambers

Thanks for your suggestions, Andrée . I've submitted an enhancement request with this title: "Enhanced logic in Dynamic View filters with OR logical operator".

Your guidance for using "has any of" is a good workaround for the example I gave. Thanks for that. I simplified my original question so it would make sense. However in reality, I need a filter that would show ALL of the assignments for a team member, like so:

Show rows where

Project Lead is Mike

OR

Tech Lead is Mike

OR

Consultant is Mike

Andrée Starå

You are more than welcome!

Glad to hear that it worked for your present use-case.

✅Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mark Katz

I don't see the "has any of" option in my options. The "OR" logic within the same field or between multiple fields would be most helpful.

Is there a reason I'm not seeing "has any of" as an option?

Thanks,

Mark

Andrée Starå

Hi @Mark Katz

What type of column is it?

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

afleming

Dynamic view is so weak. Can't filter on OR. Can't filter on dates. I can't believe this is a paid upgrade. I can filter for "Contains" but am unable to enter multiple values. There is no "Contains any of" filter (anymore, apparently)

Andrée Starå

https://community.smartsheet.com/discussion/comment/391959#Comment_391959

Hi,

I hope you're well and safe!

You can set the filter on the sheet/report instead.

For the right use case, Dynamic View is fantastic. Imho. ;)

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

afleming

No, it doesn't help, since I want the filter to be optional, not always on. I had to create a calculated field for all of the value combinations, which is stupid to have to do as a workaround when building in "OR" logic would be ridiculously simple.

Andrée Starå

https://community.smartsheet.com/discussion/comment/391992#Comment_391992

Ok. I agree, "OR" would be an excellent addition.

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Adrian Mandile CHESS

Hi @Genevieve P., @Andrée Starå, @MikeChambers, @Mark Katz,

It’s been 5 years since this original post about the missing functionality for an OR filter in Dynamic View.

Is it any closer to being resolved with the advent of the new sheet architecture? If not, is there a roadmap for when it is likely to be addressed. It is such a basic expectation when using logic that we can use combinations of AND/OR - like is possible in Reports or even Sheet filters.

The only other ‘work-around’ is to point the DV to a report instead of a sheet.

Genevieve P.

Hi @Adrian Mandile CHESS

Here is the related Product Idea post to vote on and add your comments: Enable 'OR' filter in Dynamic Views

If there is a roadmap update, it will be posted on that thread.

Cheers,
Genevieve