Trying to do a filter base on a date
I am capturing time and attendance. I have a field called Week Ending (Saturday) . I would like to to display the The previous week timecards for 5 days after the week ending date then I want the report to only show the new entries from that point until the 5 days past the end date repeating the cycle
Best Answers
-
You'll want to setup 2 filters with the OR between them like the screenshot above. The first one you'll select "is in the last (days)" and the other one you'll select "is in the next (days)".
If you need to exclude a day such as today, you'd set it up like this:
-
Ended up with this ! TY
Answers
-
You'll want to setup 2 filters with the OR between them like the screenshot above. The first one you'll select "is in the last (days)" and the other one you'll select "is in the next (days)".
If you need to exclude a day such as today, you'd set it up like this:
-
If that doesn't work, you'll need to set up helper columns on your sheet which calculate the start date for the last 5 days and the end date for the last 5 days...then the same for the start/end dates of the next week. Then set up your filters to show what's between those date ranges.
-
Ended up with this ! TY
-
Is there a reason these filter options wouldn't be an option?
That's my current case and I'm unsure why?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives