Is there any way to filter a schedule to only show activities occuring for a period?

adbower

If I have a schedule that is out to a year, but I want to filter for a schedule each week that only shows the previous week and the next 3 weeks, is there a way to do that? Start date and finish date filters don't work that well for that type of filtering. Truly, what I want is to show activities that have a bar going through any day during a certain timespan. 

Another way to say it would be if you were looking at the gantt chart for the entire schedule, I'd only want to see activities that show a bar going through during a certain timeframe. 

Andrée Starå

Hi,

You'd need a so-called helper column that, for example, would have the formula to calculate one week back and the next three weeks.

You could then also use it to show it in a report.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

adbower

That idea is something that didn't cross my mind, but I'm not sure how I would use that to help this situation...

Andrée Starå

I missed this post.

Have you solved it or do you still need help?