Options
Mengdong Zheng ✭✭
06/22/20 edited 06/22/20 in Smartsheet Basics
A number of questions. Please provide an "yes/no" answer, following with further elaboration.
1) In the resource management view, the resources are sorted by their names. Is it possible for me to include additional information about the resource (such as department, email, etc.) as a column in the resource management view and then sort based those additional columns?
2) If it's currently not possible to question 1, is it possible to create a separate sheet to add the more resource information in columns (department, email), and at the same time refer the information from resource view in the same sheet?
3) Is it possible to set certain project as subjected for resource management in one view, but not another? For example, if I create one resource view and include this project, I'd like to see the resource allocation with the workload of this project. However, in another resource view, I doesn't want to see that project.
4) Is it possible to track planned resource allocation versus the actual resource allocation? For example, in project plan I have the 20% allocated to one resource, and I want to track the actual load on the resource as how many hours spent on the project in that week (say 12 hours), so I can compare the planned 20% versus actual 30% (12/40).
Thank you
0 · Share on FacebookShare on Twitter
Ben Goldblatt Employee
06/29/20 Answer ✓
Options
Hi @Mengdong Zheng,
Within the core application it isn't currently possible to customize Resource Views to include additional information or to change the way resources are sorted. You could insert columns in a sheet to list Department names and email addresses and you may be able to use cross-sheet formulas to populate that information based off of a resource's name, but Resource View information can't directly be referenced.
While you do have an option to create custom Resource Views, the filtered options for "By Project" and "By User" will both include other projects where resources are assigned. This can help inidentifying potential scheduling issues.
For the features you're looking for that aren't supported at this time, submit aProduct Enhancement Requestfor these to be considered as possibilities for future development. I also highly recommend looking into our 10,000ft application which offers more Resource Management capabilities such as time tracking and reporting capabilities that may help with the allocation comparison you're looking for.
For more information on Smartsheet's built-in Resource Management functionality and 10,000ft, check out the following Help articles from the Smartsheet Learning Center:
Smartsheet Resource Management
- Resource Management and Allocation
- Gain Insight into Resource Allocation with Project Resource View
10,000ft
- 10,000ft by Smartsheet
- Track Time in 10,000ft
- Reports Overview
- Resource Management Content Center
I hope this helps!
Thanks,
Ben
5 · Share on FacebookShare on Twitter
Answers
Ben Goldblatt Employee
06/29/20 Answer ✓
Options
Hi @Mengdong Zheng,
Within the core application it isn't currently possible to customize Resource Views to include additional information or to change the way resources are sorted. You could insert columns in a sheet to list Department names and email addresses and you may be able to use cross-sheet formulas to populate that information based off of a resource's name, but Resource View information can't directly be referenced.
While you do have an option to create custom Resource Views, the filtered options for "By Project" and "By User" will both include other projects where resources are assigned. This can help inidentifying potential scheduling issues.
For the features you're looking for that aren't supported at this time, submit aProduct Enhancement Requestfor these to be considered as possibilities for future development. I also highly recommend looking into our 10,000ft application which offers more Resource Management capabilities such as time tracking and reporting capabilities that may help with the allocation comparison you're looking for.
For more information on Smartsheet's built-in Resource Management functionality and 10,000ft, check out the following Help articles from the Smartsheet Learning Center:
Smartsheet Resource Management
- Resource Management and Allocation
- Gain Insight into Resource Allocation with Project Resource View
10,000ft
- 10,000ft by Smartsheet
- Track Time in 10,000ft
- Reports Overview
- Resource Management Content Center
I hope this helps!
Thanks,
Ben
5 · Share on FacebookShare on Twitter
Mengdong Zheng ✭✭
08/15/20
Options
Thanks for the information! Ben. This helps.
0 · Share on FacebookShare on Twitter
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("searchbox"+index); Coveo.initSearchbox( searchBoxRoot, "https://search.smartsheet.com/community/" ); }); $('#titleBar .CoveoSearchbox').hide(); $('.coveoSearchButton').on("click",function(){ $('#titleBar .CoveoSearchbox').toggle(); }); // ====== Front Page Search Box ====== $('#Form_search').remove(); var boxes = ["#search-0", "#search-1", "#search-2", "#search-3", "#search-4", "#search-5"]; console.log("PT: Before search box replacement"); $(boxes).each(function(i, val) { // ====== Front Page Search Box ====== $(val).each(function( index ) { console.log(this); $('#searchbox' + i).remove(); $(this).find('form').remove(); $(this).addClass('fpsearchbox'); $(this).attr('id', 'fpsearchbox' + index); $(this).append('
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("fpsearchbox"+index); var action = "https://search.smartsheet.com/community/"; if ( $('body').hasClass('Categories')) { var category=$('h1.heading-1').text(); if (category === "Smartsheet Product Feedback & Ideas") { category = encodeURIComponent(category); Coveo.$(searchBoxRoot).on('buildingQuery', function(e, args) { args.queryBuilder.advancedExpression.addFieldExpression('@communitycategory', '==', [category]); }); action = action + '#&f:@communitycategory=['+category+']'; } } Coveo.initSearchbox( searchBoxRoot, action ); }); }); });
Categories
- All Categories
- 14 Welcome to the Community
- 61.2K Get Help
- 294 Global Discussions
- 206 Industry Talk
- 407 Announcements
- 13 Community Corner Newsletter
- 124 Brandfolder
- 150 Just for fun
- 120 Community Job Board
- 25 Member Spotlight
- 1 SmartStories
- 285 Events
- 27 Webinars
- 7.3K Forum Archives
Watch video