Is there a way to filter based on Home Teams matching with any object in $$USER's Other Teams?

[NastasyaCl2]

I'm trying to create a dynamic report that will show the user all other users' timesheets from the previous week, as long as the users' Home Teams match any of the teams in the $$USER's Other Teams.

I ALMOST have it working but there are holes that I'm not quite understanding or know how to fix. This is how I currently have it setup:

startDate=$$TODAYb-1w
startDate_Mod=between
startDate_Range=$$TODAYe-1w
user:homeTeamID=$$USER.teamIDs
user:homeTeamID_Mod=in

For Example:

• Tony's Home Team is Marketing - Digital Optimization.
• Rebecca's Home Team is Marketing - Product Management
• Stacie's Home Team is Marketing - Product Management but they also have Marketing - Digital Optimization in their Other Teams... as well as Marketing - UX/UI and Marketing - Directors.

In this example, Stacie should be able to see both Tony and Rebecca's timesheets on the report because both their Home Teams are included in Stacie's list of Other Teams.

Like I said, this is kind of working and I'm able to spot check various Managers and Directors that they do have some people in their list, but it's not capturing everyone even though I've verified that the Home Teams are included in the Manager/Director's Other Teams lists. From what I can tell, it's because their Other Teams lists aren't matching, but I wouldn't expect them to need to if all I care about is matching the Home Team to any of the values in Other Teams.

Any help or guidance would be greatly appreciated, thank you!

[skyehansen]

I feel like it would be a bit weird if everyone could see anyone's timesheet purely because of them being on the same team.

It feels more likely that people can see other people's timesheets because they've been identified as an approver on the timesheet profile that was attached to the other team members.

Are you able to speak to what everyone's timesheet profile is set to?

https://experienceleague.adobe.com/en/docs/workfront/using/timesheets/create-and-manage-timesheets-i...

[NastasyaCl2]

Ideally, the report would only be available to Managers and Directors so not just anyone can see anyone else's timesheets. 

I would like to avoid just going with the route of using direct approver because I would like for skip levels to be able to self-serve this information, as well, hence why I would like to display timesheets based on teams. 

If there is an easier way to do that, that would be great!

[skyehansen]

If you're able to clarify that for the users who can't see timesheets it's because they are not the designated approvers, that would help us cut through to the expected functionality. So hopefully you can answer this part?

After your clarification, I can probably then confirm that reports will always only show what a user is "allowed" to see. So if a user isn't allowed to see a particular timesheet then they also will not see this timesheet on a report, and there's nothing in text mode to correct this.

And while there are some allowances, like "run with ___ rights" to show a report viewer someone else's ability to see an object, this doesn't at all combine with wildcards -- so it will show you the teams for the user you're using the rights of.