Formula to check box on header row if any rows nested under it have a specific owner/assigned to
Hello, I am trying to work out if the following scenario is possible.
I have a bunch of parent tasks / child tasks. I have these child tasks feeding into a report/dashboard IF the assigned to is "Client" and want to include the headers where appropriate (ex. I don't want to pull through ALL the header rows on the sheet if there are no child tasks assigned to the client)
I was thinking of making a checkbox column called "include on report" for the header rows, then I can filter the report to include the rows with that column checked. However, I want to automate it with a formula so that if we add a child task and assign it to the Client, it will auto check the box and include that header row. and it needs to EXCLUDE any rows that are assigned to the Client, but the "Done" column checkbox is checked.
Thanks for your help!
Help Article Resources
Check out the Formula Handbook template!