Permissions on sheets using control center

AnnaKisting ✭✭✭
edited 05/07/24 in Add Ons and Integrations

Hey Everyone-

I'm using control center to create sheets of tasks lists.

I've got the project owner on several tasks and I created a report union-ing all of the tasks. (So far everything I'm describing is out of the box capability with SS CC).

My project Owners want a report that show all of the tasks on their projects. What is the easiest way to do this? There are a lot of people and the people rotate in and out, so I was hoping to use the current owner filter. Is there a way in control center that I can dynamically set a column so that Project owner shows up on every row - which would allow me to create this filter?

Has anyone else come up with a creative way to show project owners all of their tasks across all of the projects in a single view?