Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

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

edited 12/09/19 in Archived 2017 Posts

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.


This discussion has been closed.