Formula to check Child Row checkbox if Parent row contains "ABC Dept" (filtering by Department)
I have a "Master" project resource sheet with great grandparent rows for "Current Projects" and "Future Projects", Then grandparent rows for each "Project", parent rows for department and child rows for the individual resources per department.
I'm trying to create a filter to filter resources by department across all projects. I can manually create a filter that has all resources from a department checked within the filter, but I have to maintain that list! Instead I would like to use a formula in check box column to check automatically if criteria are met and filter based on checked/unchecked status. I will have one column and one filter for each department (5 total) The columns span all projects. I will keep the "include parent rows" option checked in the filter to keep the sheet structure. The check box needs to be ticked if the child row's parent is "department_name" which is in the primary column
I'm struggling to compile the formula to check the box if the parent (department) row is "PM" for example. I don't want there to be any Dedicated cells involved so it can be applied generally to an entire column.
Have been using checkboxes and formula's for a while to generate conditions for conditional formatting and part of me thinks this formula should be simple enough!