One trick is to create a calculated field on the user form named Manager Chain This is the approximate code, I don't have it set up currently: CONCAT(user.manage.name, ", ", user.manager.manager.name, ",", user.manager.manager.manager.name ...) Then with this field you can just do a filter that the assigned to.Manager Chain contains $$USER.name and you'll have a report that all managers can use to see their groups tasks/projects/hours/etc. On Mon, Aug 15, 2016 at 12:57 PM Beth Massura < reportingforum@communitylists.workfront.com> wrote: > Our org structure recently changed so our creative director (who manages > all designers) now reports to our content director (who already managed and > will continue to manage all writers). The content director wants a > dashboard that shows all tasks for anyone on those teams - everyone who is > below her on the org chart. There are other similar structure changes where > what used to be a separate team has been moved under another team's lead so > it would be most helpful to use wildcards rather than hard-code reports so > we can easily distribute them to the new super-team-leads. > > In the past we had reports that used "Assignment Users Home Team ID in $$USER.HomeTeamID" > to show a team lead the tasks for their team. However the content > director's home team is not "Creative Team", it's "Content Team". The > Creative Team just happens to report to her. > > One idea was to somehow expand upon "Assignment Users Manager ID in $$ > USER.ID" and maybe there would be a way to use text mode to modify it so > it was the logged in user or their direct reports. But that might be > wishful thinking. > > Any suggestions would be appreciated! > > > > Beth Massura > Assistant Director of Operations, Marketing > > The University of Chicago > Booth School of Business > 5807 South Woodlawn Avenue > Chicago, Illinois 60637 > > Phone: 773.702.7598 > > -----End Original Message----- >
