Let’s say I have two columns and they share a status value of A.
So column 1 has status values of A, B, C, D. While column 2 has status values of X, Y, Z, A.
I want to filter the view to show the following all at the same time:
Column 1: Status = A and Column 2: Status NOT A
Column 1: Status NOT A and Column 2: Status = A
The two columns will never both be at status A.
Status A is for a task that is performed at the beginning and end of the project by the same person.