Show ONLY Tasks in a Date Range

Is there any formula and/or filter that will enable me to show only the tasks that are scheduled to happen during a particular 3 week time frame, much like a 3 week lookahead. I want to show tasks that, during the time frame, have the following criteria.

Begin and End AND is INCOMPLETE
OR Begin AND is INCOMPLETE
OR End AND is INCOMPLETE
OR Start Before and End During AND is INCOMPLETE
OR Start During and End After AND is INCOMPLETE
OR Start Before and End After AND is INCOMPLETE

I cannot seem to figure this one out.

Find more posts tagged with

Construction

Project Management

Accepted answers

All comments

MCorbin

Yes, this is possible, but I need some clarification...

Is there a difference between Begin and End and Start and End?

I'm trying to grasp the difference between your first 3 criteria and last 3. A screenshot of your sheet might be helpful.

What is your 3 week timeframe? Is it always current plus the next 3 weeks? Or is it something you want to be able to set? (last 3 weeks? next 3 weeks? Starting on 6/1?) Does it start based on a date column on your sheet? Or maybe Today + 3 weeks?

Wesley Cross

I apologize for the miscommunication.

There is no difference between Begin and Start. Hopefully the below revision is more clear.
- Starts During and Ends During AND is INCOMPLETE
- OR Starts During and Ends After AND is INCOMPLETE
- OR Starts Before and Ends During AND is INCOMPLETE
- OR Starts Before and Ends After AND is INCOMPLETE
The Next 3 Weeks is the timeframe. Although, it would also be helpful if I could change between: The Next 1 Week, The Next 2 Weeks, and The Next 3 Weeks.

I want to see only the items that are scheduled to happen between the two red lines on the screenshot below.

Cid

Did you ever get an answer? I'm also having trouble selecting a range of dates for a report if the date doesn't explicitly include a date in the 'start date' or 'end date' columns.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.