Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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?

Avatar

Level 2

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

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.

Avatar

Level 2

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