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

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.

Find more posts tagged with

Reports

Project Management

Accepted answers

All comments

Paul Newcome

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.