How do I add a contact to a report that’s pulling select tasks from multiple project schedules?

KelleyS

Newer user here!! What’s the best method to pull a contact (PM Assigned To) from an intake sheet into a report that’s already pulling select tasks (Materials) from multiple project schedules? 

I'd like to be able to show the project manager, as well as sort by PM, for the project on a materials report; which is a list of material due dates currently sorted by project name. Right now, the PM assigned to the project only appears on an intake sheet, not on the actual project schedule itself. And I'd like to have a way to combine the two sheets so the information can be displayed in one report.

Paul Newcome

You would have to put the formula to pull the contact on the source sheet.