Can I filter with a date formula?

I'd like to filter to show "Open tasks and recently closed tasks". I have this working but "recently closed tasks" is hard coded to ">= March 1, 2017". Can I use a formula for this?

I tried to use "=Today()" but that says "Invalid Date" (with or without the quotes).

Is this possible?

Find more posts tagged with

Formulas

Comments

J. Craig Williams

Bill,

You can not use a formula in the Filter criteria.

However, there are several options available that may get you want you want without adding a column to do your own formula calculation.

Check these out and see if helps.

Craig

joecross98

+1 for this feature

I want to filter an End Date column in Gantt view to see all tasks due this month. I have to update the filter every month since there is no formula support.

Maybe add it alongside "is in the future"?