Filter for dates in between start and end date
ajuelsgaard
✭✭
I have start date and end date columns in my sheet. I would like to be able to filter for all lines that have a date that falls between those dates. So as an example, if I have a start date of August 1 and an end date of November 12, I want to be able to filter for all lines that will happen in October. Neither the start or end are October dates but it does fall between the start and end. Is that possible?
Answers
-
You would set your filter so that it has the Start Date being less than or equal to 31 Oct and the End Date greater than or equal to 1 Oct.
This will show you all rows that overlap October.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives