OR in the Dynamic filter

Hi,

How does one create an OR filter for two fields in the Dynamic filter?
image
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

1 Like