So… if I want to show the results only when both criteria are fulfilled, I use ‘OR’.
If I want to show the the results of each single criteria, I’m supposed to use ‘&&’?
It is the opposite!
In your case criteria to hide are:
- Status in completed
- Row was modified more than 3 days ago, let name this Old
So, the row should be hidden if both criteria are true.
Pseudo formula will be:
Hide row = Completed AND Old
AND are the same, you can use && as such as AND with no difference. For the
OR operator there is also
But we want to write criteria to show row, not to hide it, because
Filter formula asks us what we want to show. This criteria can be
Show row = NOT (hide row) = NOT (Completed AND Old)
And this formula will work if you try. However, we can open parenthesis. Unfortunately, we can’t just write
NOT Completed AND NOT Old because boolean algebra works different.
Imagine you have box of socks, some of them are red, some are white. And also some are big and some are small. If some sock is
not (red and big) it can be:
- white and big
- red and small
- white and small
It is totally different from
not red and not big, isnt it? These three sock types perfectly match criteria
white OR small. Each of this types is at least white or at least small. Or in other words:
not red OR not big. See?
NOT (red AND big) = NOT red OR NOT big
yes, sounds crazy Is it called De Morgan’s laws
Back to your data:
Show row = NOT (hide row) = NOT (Completed AND Old) = NOT Completed OR NOT Old