SOLVED

Additional column to show resources from one resources-group

%3CLINGO-SUB%20id%3D%22lingo-sub-196743%22%20slang%3D%22en-US%22%3EAdditional%20column%20to%20show%20resources%20from%20one%20resources-group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-196743%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20Community%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20additional%20columns%20to%20show%20only%20resources%20from%20the%20same%20type%20of%20resources-group%20assigned%20to%20a%20task.%20(Please%20see%20example%20in%20picture)%3C%2FP%3E%3CP%3EHow%20should%20a%20formula%20look%20like%20to%20achieve%20this%20filtering%3F%20Or%20are%20there%20other%20options%20to%20achieve%20this%3F%20Im%20using%20Project%202013.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34690iD7163E833511DE4C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ressource%20column.png%22%20title%3D%22ressource%20column.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20an%20example%20of%20the%20resources%20table%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20730px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34692i9CB2DBBB96BC759C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Ressources_table.png%22%20title%3D%22Ressources_table.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20for%20weeks%20now%20but%20can%E2%80%99t%20get%20it%20working.%20Any%20help%20is%20highly%20appreciated.%3C%2FP%3E%3CP%3ERegards%2C%20Jochen%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-196743%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-201223%22%20slang%3D%22en-US%22%3ERe%3A%20Additional%20column%20to%20show%20resources%20from%20one%20resources-group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201223%22%20slang%3D%22en-US%22%3EI%20think%20this%20is%20what%20I%20may%20be%20looking%20for%20but%20could%20you%20provide%20this%20in%20English%20please!!!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-198095%22%20slang%3D%22en-US%22%3ERe%3A%20Additional%20column%20to%20show%20resources%20from%20one%20resources-group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198095%22%20slang%3D%22en-US%22%3EAnswered%20here%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fde-de%2Fmsoffice%2Fforum%2Fmsoffice_project-mso_winother-mso_2013_release%2Fproject-zus%C3%A4tzliche-spalte-f%C3%BCr%2Fb583c636-cb0b-46e1-90de-62af141df505%3FmessageId%3D20e1fb7b-2f03-4f83-a9e5-a0b8e3e46e1c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fde-de%2Fmsoffice%2Fforum%2Fmsoffice_project-mso_winother-mso_2013_release%2Fproject-zus%C3%A4tzliche-spalte-f%C3%BCr%2Fb583c636-cb0b-46e1-90de-62af141df505%3FmessageId%3D20e1fb7b-2f03-4f83-a9e5-a0b8e3e46e1c%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-196939%22%20slang%3D%22en-US%22%3ERe%3A%20Additional%20column%20to%20show%20resources%20from%20one%20resources-group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-196939%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20imagine%20you'll%20be%20able%20to%20do%20what%20your%20setting%20out%20to%20do.%20A%20poor%20workaround%20might%20be%20to%20create%20custom%20attributes%20that%20you%20manually%20type%20the%20names%20into%2C%20but%20there's%20no%20%22people%20picker%22%20for%20custom%20attributes%2C%20so%20there%20wouldn't%20be%20a%20direct%20tie%20to%20your%20actual%20resources%20(both%20assigned%20to%20the%20task%2C%20nor%20even%20to%20the%20actual%20resources%20in%20the%20project%20since%20you%20could%20just%20as%20well%20type%20arsdgfadxflkjh%20as%20you%20could%20ActualNameOfResource.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20-%20doesn't%20seem%20to%20be%20setup%20to%20do%20what%20you're%20looking%20for.%20Other%20people%20have%20tried%20for%20similar%20things...%20such%20as%20in%20Project%20Online%20displaying%20for%20a%20list%20of%20projects%20columns%20with%20the%20resources%20assigned%20by%20role%2C%20but%20I%20don't%20think%20that%20ever%20worked%20out%20for%20them%20either.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

 

Hello Community,

I am trying to create additional columns to show only resources from the same type of resources-group assigned to a task. (Please see example in picture)

How should a formula look like to achieve this filtering? Or are there other options to achieve this? Im using Project 2013.

 

ressource column.png

 

 

 

 

This is an example of the resources table:

 

Ressources_table.png

 

 

I tried for weeks now but can’t get it working. Any help is highly appreciated.

Regards, Jochen

 

 

 

3 Replies
Highlighted

I can't imagine you'll be able to do what your setting out to do. A poor workaround might be to create custom attributes that you manually type the names into, but there's no "people picker" for custom attributes, so there wouldn't be a direct tie to your actual resources (both assigned to the task, nor even to the actual resources in the project since you could just as well type arsdgfadxflkjh as you could ActualNameOfResource.

 

Sorry - doesn't seem to be setup to do what you're looking for. Other people have tried for similar things... such as in Project Online displaying for a list of projects columns with the resources assigned by role, but I don't think that ever worked out for them either.

 

Highlighted
Highlighted
I think this is what I may be looking for but could you provide this in English please!!!!