Filter

[bh1789]

I am trying to filter 2 columns, Monitoring and Year, but it is not working ... any suggestions?  Thank you

[Monitoring] = "Email" AND Contains([Year], "2023") OR
[Monitoring] = "Email" AND Contains ([Year], "2022") OR
[Monitoring] = "Email" AND Contains ([Year], "2024")

[Qiu · Accepted solution]

@bh1789 
Try something as below.
We need to group the conditional statements

([Monitoring] = "Email" AND Contains([Year], "2023")) OR
([Monitoring] = "Email" AND Contains ([Year], "2022")) OR
([Monitoring] = "Email" AND Contains ([Year], "2024"))

or 

[Monitoring] = "Email" AND 
(Contains([Year], "2023") OR Contains ([Year], "2022") OR Contains ([Year], "2024"))