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?

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?
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"?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 448 Global Discussions
- 154 Industry Talk
- 504 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 513 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives