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

edited 11/22/22 in Formulas and Functions

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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!