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
✭✭
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
-
+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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.3K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives