Is there a way to filter based on Home Teams matching with any object in $$USER's Other Teams? | Community
Skip to main content
N
NastasyaCl2
Level 2
June 19, 2025
Question

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

  • June 19, 2025
  • 2 replies
  • 446 views

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!

 

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

2 replies

skyehansen
Community Advisor
skyehansenCommunity Advisor
June 20, 2025

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-in-adobe-workfront/create-timesheet-profiles

    N
    NastasyaCl2Author
    Level 2
    June 20, 2025

    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
    Community Advisor
    skyehansenCommunity Advisor
    June 20, 2025

    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.

      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      July 29, 2025

      @nastasyacl2 Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

      Kautuk Sahni
      Terms & ConditionsAccessibility statement

      Loading footer...