Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
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
