Skip to content
  • Try Smartsheet

    • 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:
    · Share on FacebookShare on Twitter

    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

      · Share on FacebookShare on Twitter
    • ✭✭

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

    Quick Links

    Categories

    Trending Posts