Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Can I filter with a date formula?

Bill Peck
Bill Peck
edited 12/09/19 in Archived 2017 Posts

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?



  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭


    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.



  • 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"?

This discussion has been closed.