Pulling Job role in a report
Hi Gurus!!
I am working on a report/calculate field that I need created. So here is the problem statement:
One of the clients want to track the name and job role of a resource on a project. As you all know that a particular project may have many stakeholders, so to keep one person responsible (apart from the Project Owner), I have created a typeahead custom field for the user (lets call it "Responsible Person". On a report I need to figure out what is the Job Role for this "Responsible Person". Dont really mind if its a calculated column or a calculated field I'll need to create to get this information.
Please help!!