Hey all,
I have a good brain teaser.. well at least I think it is. I am trying to build a view in my project file where I group my tasks by department. Here is the thing: I need to use the 'Resource Names' column which contains multiple departments per action.
So every task has an assigned department but also has several other departments that must touch that task before it can be completed. Example: Task 1, Dept-ENG, Resource Names-ENG,MFG,MSAT. Task 2, Dept-MFG, Resource Names-MFG,MSAT.
Basically, I need to show every task that each department touches. From the example from above I need the following results...
ENG
I am not sure how to do this. When I groupby department it only returns the tasks with their respective department. Can someone help please??
Thank you!
I have a good brain teaser.. well at least I think it is. I am trying to build a view in my project file where I group my tasks by department. Here is the thing: I need to use the 'Resource Names' column which contains multiple departments per action.
So every task has an assigned department but also has several other departments that must touch that task before it can be completed. Example: Task 1, Dept-ENG, Resource Names-ENG,MFG,MSAT. Task 2, Dept-MFG, Resource Names-MFG,MSAT.
Basically, I need to show every task that each department touches. From the example from above I need the following results...
ENG
Task 1
MFGTask 1
Task 2
MSATTask 1
Task 2
I am not sure how to do this. When I groupby department it only returns the tasks with their respective department. Can someone help please??
Thank you!