Permissions on sheets using control center

AnnaKisting

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?

Thanks!

Anna

Paul Newcome

You can use a field in your metadata sheets to house the lead and then use a column formula with a cross sheet reference on your project plan to output the lead on every row.

AnnaKisting

Thanks Paul! I did try that, but I can't use an absolute reference or a cell reference in a column formula. How would I make that formula work?

Paul Newcome

=INDEX({Cross Sheet Reference To Lead Cell In Metadata Sheet}, 1)

The above should get you what you need. Depending on the size of your project plan, I like to put the above in a Sheet Summary field and then reference the sheet summary field in my column formula. Having one formula with a cross sheet reference to process can improve performance over a formula on every row trying to process a cross sheet reference.