Forum Discussion
Filtering based on two calculated columns using OR
I have two calculated columns with results either showing "yes" or "no" based on due dates. How can I filter to show results that are Yes for column A OR Yes for Column B Column A ...
In the query editor, add a new custom column with a formula like this and then filter on it.
= if [Column A] = "Yes" or [Column B] = "Yes" then "Keep" else "Remove"
Pat