Filter Report by End Dates
I have a report that I am using to 'look ahead' by two weeks. However, I would also like to see any past due dates in case tasks were missed from the previous week. Is there a way to set my filters to see both upcoming dates (by two weeks) and any past due dates?
Currently, my filter is set up as status is one of 'in progress' or 'not started' and end date is in the next 14.
thank you for reading.
Answers
-
Hi @DA_Associates_PM ,
Add an "OR" to the filter group for end date to be "is in the past"
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
@hollyconradsmith I think that did the trick! I knew there had to be a simple solution! Thank you so much
-
Can you please show a screen shot of the filter criteria, I'm trying to do something similar to this and I'm having issues when I change it to "Or".
-
Hi!
This is what my filters look like. Hope this helps
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives