So I’ve gathered that I can’t use both AND and OR filters, but the workaround is to use formulas. Problem is, I can’t find a formula to solve my problem.
I currently have two columns that I want to be able to filter, a “status” column and a “release date” column.
This is the filter I want to set up:
WHERE “release date” is on or after 14 days ago
OR “release date” is empty
AND “status” is not archived.
Is this possible using formulas? Or are there too many layers? Thanks in advance for everyone’s help!