How can I run a report that includes the sheet owner as a column next to the sheet name?

Vossy

I need to send a job list to one of my suppliers. I have multiple project managers working on construction jobs, and they have a sheet for each project. 

 

Each sheet can have 3 or 4 tasks for one supplier - such as for plumbing work - and I want to create a report that shows the sheet name (which is the construction address), the scheduled date, and the sheet owner (the PM) so I can send this to the supplier.

I've got the first two columns, but how do I get the PM's name?

 

Any help appreciated.

J. Craig Williams

Vossy,

 

There is not way to access the names or sharing permission levels of persons shared to the sheet from within the sheet. 

You will need to addd that information manually to rows that  you are pulling into the report.

 

Craig