Setting up filters for displaying within a time frame

Hi
I need to set up a filter that will only display submissions to my sheet within a certain date range and then have those that are far out in the future hidden only to display when the system recognizes the submission has come within that date range.
For example:
submission= January 6, 2020
display= display only the next 45 days
All entries/rows that meet the display criteria are visible on a sheet. Entries after the criteria date are hidden from view until the real time calendar recognizes the date proximity and releases them to display...
Is this too futuristic?
thanks
Comments
-
Hi Joleary,
If I understand your requirement correctly, I'd recommend using the filter condition, is in the next (days), and input 45 as the value.
Another option could be to create a report.
Would one of those methods work?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives