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.
Help Article Resources
Check out the Formula Handbook template!