I have created a formula referencing key dates that returns the values of “Past”, “Present”, or “Future”. I would like to filter a view showing only “Present” or “Future” records. I also want to filter out any record where the status is “Rejected”
I can do (PPF means Past, Present or Future):
Where PPF contains Present
Or PPF contains Future
This satisfies my first requirement. But I’d like to add:
And Status is not Rejected
But it only allows another “Or” statement, not an “AND” statement
Alternately (preferably) I’d like to be able to say:
Where PPF contains “Present” or “Future”
Perhaps my syntax is wrong, but the filter for text fields doesn’t seem to offer boolean operations like this.
My work around is to have a single-select field rather than formula where I can just choose “Past”, “Present” or “Future”. This allows me to choose the “is any of” option in the filter. But then I have to update these fields manually when the dates come and go.
Suggestions?