SOLVED
Home

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
Jochen Lahr
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

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.

 

I think this is what I may be looking for but could you provide this in English please!!!!
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies