Need Both OR and AND Options for a Filter

Rx4PSO · 09/14/23

When setting up a filter for a worksheet, it would be better to be able to select OR/AND for each line. Currently, only having the options of either 'All conditions' or 'At least one condition' isn't sufficient for a filter.

For example, if you want to filter to see rows assigned to Jane Doe and a visit date in the future or a visit date in the past 7 days.

Gilles Syngenta · 12/21/23

This is really needed to use correctly Salesforce connector

Michele Riemann · 05/15/25

Hello,

It would be good if we were able to create AND and OR conditions when creating filters on sheets like we can in the report view. Right now all conditions have to meet all criteria or only one which limits what we can filter on.

In addition it would be nice to be able to filter out certain rows by color.

Jamie Bedford · 05/19/25

+1, still want this functionality

Sign in to submit new ideas and vote

Need Both OR and AND Options for a Filter

Idea Submitted · Last Updated 09/14/23

Comments

Categories