I again use a custom field on a custom form. Mine is a calculated field called Manager Hierarchy. This just uses the Manager's Name so requires no extra maintenance if that is maintained. Here's the calculation: CONCAT(IF(ISBLANK(Manager.Manager.Manager.Manager.Manager Hierarchy),"",CONCAT(Manager.Manager.Manager.Manager.Manager Hierarchy," - ")),IF(ISBLANK(Manager.Manager.Manager ID),"",CONCAT(Manager.Manager.Manager.Name," - ")),IF(ISBLANK(Manager.Manager ID),"",CONCAT(Manager.Manager.Name," - ")),IF(ISBLANK(Manager ID),Name,CONCAT(Manager.Name," - ",Name))) Basically this list out in name form Abe - Bob - Cindy - Diane - Ed - Frank - George Assuming that Abe is Bob's Boss, Bob is Cindy's .... and this is George's User Form But on Abe's form it's only Abe And on Bob's form it's Abe - Bob Etc. No extra punctuation (That's why I check ISBLANK so much) and arbitrary depth (but you may need to do multiple recalculations for every 4 levels of hierarchy when you are first setting up or are changing upper management). So if you have more than 4 levels of manager's, use that person's Manager Hierarchy Field, then put each manager and end with yourself. If you have no manager it will just list yourself. This lets me create manager reports where owner's manager Hierarchy contains $$USER.name and it will show only my work for individual contributor's and all of my reports and their reports if I'm a manager of any arbitrary depth. If you have significant depth in your organization reflected in Workfront, you may need to do several recalculations to get everyone to appear all the way up. -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site:
www.capabilitysource.com email: melinda.layten@capabilitysource.com - we simplify your work so you can run your business -