Is there a grouping or filter to use in a report to see all projects the employees in their home team is assigned to? | Community
Skip to main content
D
DominicTa2
Level 2
March 26, 2021
Solved

Is there a grouping or filter to use in a report to see all projects the employees in their home team is assigned to?

  • March 26, 2021
  • 1 reply
  • 527 views

Is there a grouping or filter to use in a report to see all projects the employees in their home team is assigned to? Essentially, I want to create a milestone report for someone displaying all of the projects that their team has an assignment on.

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

Hi Dominic,

Try using the Project Users data fields in your filters. i.e. create a project report with a filter appllied where Project Users >> Home Team ID equals $$USER.homeTeamID. This should return all projects where a member of project team belongs to the home team of the person viewing the report.

Hope that helps!

Best Regards,

Rich.

1 reply

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
March 28, 2021

Hi Dominic,

Try using the Project Users data fields in your filters. i.e. create a project report with a filter appllied where Project Users >> Home Team ID equals $$USER.homeTeamID. This should return all projects where a member of project team belongs to the home team of the person viewing the report.

Hope that helps!

Best Regards,

Rich.

    D
    DominicTa2Author
    Level 2
    April 2, 2021

    Hi Richard,

    Thank you so much, this is perfect! You're a genius!

    I didn't even think to look at that filter.

    Thank you again!

    Dom

    Terms & ConditionsAccessibility statement

    Loading footer...