Hello guys,
i have a project where i have severeal working ressources scattered over several teams. in my resource planner i have a field with different "team"s. In my gantt table i have projects, which are used from severeal teams. Now i want in the gantt table a custom field, which shows my the total work duration only of one team. How can i do this?


Thanks in advance

for the team field i used text 11 so i tried this formula, but it returned an error



IIf([Text11];"Teamname";[Work])

There is no easy workaround for the problem you are facing because you created a custom Resource field, which CANNOT be shown in a Task view. Here is what you can do instead. Enter the team names in the Group column for each resource in the Resource Sheet view. Then, add the Resource Group column in the Gantt Chart view. Once done, you can group on the Resource Group data. Just a thought. Hope this helps.