filter criteria date greater than or equal to today minus x days
I have a report where I want to show tasks with start dates greater than or equal to today minus x days. How can I do that in the filter criteria? ... ie tasks that are starting greater than or equal to x days ago.
Of course I could add a specific date but I want the report to work next week etc without having to update the date in the filter criteria.
As I type this I am thinking I just need a formula in the source sheet to calculate the date (eg today()-5) but just checking if this can be done without that ie directly in the filter criteria.
Answers
-
Hi @barryrowland,
That kind of filtering isn't available in reports. I agree that you need to do the calculation in the source sheet.
An idea I had is that you could create a helper column to capture this formula calculated date, and then just hide it. That way you don't alter the original date from whatever column you're grabbing it from.
Then you can include that column in your report.
All the best,
-Ray
-
Got it - thanks @Ray Lindstrom - my next question was what's a helper column but I found that on another post 😆 ... ie my take is just a normal column but used for helping purposes.
-
You got it. A help column is just another normal column that gets used for calculations and such. They're often hidden, but even hidden columns are available to select for Reports.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives