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?

Tags:
· Share on FacebookShare on Twitter

Comments

  • J. Craig Williams
    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

    DateFilterCriteria.jpg

    · Share on FacebookShare on Twitter
  • joecross98
    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"?

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories