Hi,
How does one create an OR filter for two fields in the Dynamic filter?
I need to be able to check for two values.
Thanks
Hi,
How does one create an OR filter for two fields in the Dynamic filter?
I need to be able to check for two values.
Thanks
Hi Stephen,
Itβs not supported to set up βORβ filter.
You can create a free text / selection field (Y/N) in your source sheet, and use βIF()β formula to check if it meets your OR criteria, if yes, returns βYβ, if not, returns βNβ, so you can use value βYβ to set up dynamic filtering.
Cool that makes sense.
Thanks a ton and have an awesome day