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")
Solved! Go to 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"))