filtering tasks taking place in a specific calendar week

Piotr Górczewski · 07/13/21

Hi,

I've created production plan which is used by different departments for planning, checking, production capacity calculation's.

I would like to create a filter which shows all tasks taking plate in specific calendar week.

For exaple:

I know that in week 44 I will have overbooking on production capacity, if I won't reschedule some of the tasks.

I would like to have a possibility to filter all those tasks in specific week, which going to start/finish/or continue in specific calendar week.

Thank You in advance for any help from Your side.

Bassam Khalil · 07/14/21

Hi @Piotr Górczewski

Could you please share me as an admin on a copy of your sheet after removing any sensitive data so I can solve this problem for you.

Bassam Khalil · 07/14/21

Hi @Piotr Górczewski

Hope you are fine, you can do that by adding a helper column call it week number and use the following formula to calculate for each task:

=WEEKNUMBER(Date@row)

then you can create a report filtered by Department & overbooking on production capacity and group that report using Week number. the following screenshot shows a sample

Piotr Górczewski · 07/14/21

Hi @Bassam Khalil,

Thank You for the hint about "WEEKNUMBER" formula.

I will have to look deper in to the potential of this solution.

Here You have an example of my schedule.

I've added "Week" column but i don't know how to write the formula which will calculate in which weeks "STEP" column Starts + have a duration and than Ends.

I'm wondering if there is any option to write this formula to show all the weeks in which each STEP exists.