Newbie Question - Reports Lookup into Sheet (relational database like)
First, I am sure this has been answered, but I could not find it. I have two smartsheets: Projects and PMs. The PMs sheet has basic info about the PM (Emp ID, Name, Email). The project sheet has all the projects we are working in the company with lots of project metrics. One being Margin %.
I want to create, then run a report that lists the project, project manager name, project manager email and margin if margin <5%.
Is there a way from within the report to lookup the employee info (specifically name and email) using the employee id from the project sheet.
THanks in advance