Filter on two values

BrettFL

I'm trying to create a filter that would keep all rows except when:

Column B [Portfolio] = Information Technology and column D [Configuration Item] is empty.

Column B [Portfolio] = Mercury and Column D [Configuration Item] is empty.

If Information Technology or Mercury have configuration items then they should not be removed.

Appreciate any help!

Export from Workflow1 - Copy.xlsx

pedrodrfaria

HI @BrettFL 

Is this what you are looking for?

[Portfolio] = 'US Information Technology' and !IsNull([Configuration item]) or
[Portfolio] = 'Mercury' and !IsNull([Configuration item])

Pedro.

Filter on two values.yxmd