Archived 2017 Posts

Archived 2017 Posts

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?

✭✭
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:

Comments

  • ✭✭✭✭✭✭

    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

  • +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.

Trending Posts