Feb 06 2022 03:31 AM
Hi,
I am in the process of updating and managing our work projects log. As you will see from attached document I have merged rows at the beginning of the table to allow each project to include a basic Gantt chart to detail timeline for different aspects of each project.
When filtering I cannot perform the function correctly to hide a complete project when I say, deselect any project which has reached 100% progress, as this only hides the top row (where the merged data is located)
Is it possible to have a function to allow me to hide each completed project when selecting either project phase (to-do, ongoing, complete) or percentage complete?
Feb 06 2022 03:55 AM
@MalcolmBrowning One good reason not to use merged cells. They often cause trouble. Just like you have discovered now. Consider to un-merge the 4 cells, repeat the percentage in each of them and use conditional formatting to have the font colour blend in with the back-ground. Basically similar to how you coloured the first column now. Then you can filter as desired.
Feb 06 2022 03:56 AM
Feb 06 2022 08:57 AM
I am trying to insert this formula into the spreadsheet as you have mendtioned. Could you give me a written out complete formula for the first group of boxes please as i cant seem to get it to work. Do i change every n for one row number or for each consecutive row number?
so In cell I4 the formula would be IF(An="",I(n-1),An)
In cell I5 the formula would be IF(An="",I(n-1),An)
In cell I6 the formula would be IF(An="",I(n-1),An)
In cell I7 the formula would be IF(An="",I(n-1),An)
Feb 06 2022 07:40 PM