I have a current projects report that uses prompts to show any projects by the sponsors home team ID. I want the same exact report but the prompts to show by who the project was assigned to, not the sponsor and I can't figure out how to change the condition to find the assignee and not the sponsor. The condition I'm currently using is below.
sponsor:homeTeamID=---------------&sponsor:homeTeamID_Mod=in
I just need to know what to change sponsor from to have the condition in the prompt show who the project(s) were assigned to.
Any help is appreciated!
Thanks
Justin