Setting up filters for displaying within a time frame

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

Find more posts tagged with

Comments

Andrée Starå

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

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to prevent a shared user from seeing the data in the "View Detail" option?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option? I'm trying to make sure that when a user is given access to view a report, they can only view the columns present in that report. The view might only show certain columns but the user can then click on the record as shown below and…
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…
Changing how items are displayed on the calendar
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…