Forum Discussion
Filter - Drop down menu to show rows with cells with one or more values
The FILTER function is indeed expandable:
=FILTER(Table1[[Proj Name]:[Random3]],(Table1[StartWeek]<=RequestedWk)*(Table1[LastWeek]>=RequestedWk))
Gets the larger table view (as you can see in the attached). The key is in the red, where it now displays the starting column and the finishing.
It could also be sorted, if that were important. Just nest the FILTER formula within a SORT and specify the column on which the sort is to be based.
mathetes thank you - Yes, there is no need to make it difficult, two columns; start + end date would work fine. The filter function need to apply weeks, because the method envision weekly reports. The filtering is as such, just there to force them to only report on issues tied to a spesific week, and not everything else in the plan.
We could just add a column "status report" in the project plan and work in the same sheet, but the plan is made at one stage and the reporting in a later, and there is a cut of date. We could just make a copy of sheet 1 at the cut of date, but this is expecting to much of the project managers. So the template need to automate that process and hide the "only project plan relevant" information in the report sheet - and filter project activites relevant for a spesific week.
Would it be able to expand your formula to include export of the whole row in sheet 1 being active in the relevant week?
The FILTER function is indeed expandable:
=FILTER(Table1[[Proj Name]:[Random3]],(Table1[StartWeek]<=RequestedWk)*(Table1[LastWeek]>=RequestedWk))
Gets the larger table view (as you can see in the attached). The key is in the red, where it now displays the starting column and the finishing.
It could also be sorted, if that were important. Just nest the FILTER formula within a SORT and specify the column on which the sort is to be based.