Welcome!

Level a resource in a Sheet?

I've imported a project into a project sheet and now would like to level the resources that are overallocated so the schedule adjusts to show the actual schedule if I use these resources. Is there a way to do this?

Thanks in advance,

Sue

Find more posts tagged with

Support

Comments

Isaac Jose

Hello,

Thanks for your post! Currently, there isn't a feature which will automatically level out or reschedule over-allocated resources in your project, but you can submit a Product Enhancement Request using the quick link to the right. You'll want to manually re-allocate your resources according to your needs. It may be helpful to insert two additional date columns for Planned vs Actual Start and Finish dates which can be switched in the Project Settings to give you different views of the sheet. I've linked some additional resources for this below:

I hope this helps!

Isaac J

Smartsheet Support

bashby

This is disappointing. Unfortunately the lack of this feature disqualifies the software for my organization. Is this on any sort of roadmap?

Andrée Starå

Hi,

Have you looked at 10,000ft?

Smartsheet presented some more details about the 10,000ft capabilities at Engage.

More info: https://www.smartsheet.com/content-center/best-practices/engage-content/better-together-smartsheet-10000ft-story

https://www.10000ft.com/

More info: https://www.smartsheet.com/content-center/news/smartsheet-acquires-10000ft-enhance-resource-management-capabilities

Speaking more broadly, with the integration of 10,000ft, Smartsheet customers will benefit from the ability to plan and allocate resources across their projects, optimize resource allocation by function or skill set, track time against forecast, and gain real-time portfolio level visibility into the status of budgets and deliverables.

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Matsu Thornton

Hi, I currently have smartsheet and 10000ft but can not find the features that can level resources similar to MS project. Is there a leveling feature? We may have to switch back to MS Project because it is difficult as tasks move around to reallocate resources manually.

Also, is there a split-task feature because this also makes the process difficult when resources need to be shared among our tasks.

James D

Has this been updated in recent years? I also need to level resources so a valid schedule is created. Is the only way to create a schedule to add predecessors in for each task?

Thanks,

James

enzo_vaire

Hi,

Following on from James' comment, has this been updated? If not, I will have to give up on Smartsheet - without this feature it's too limited to justify its use.

All the best,

Enzo

Sign in to join the conversation!

Quick Links

Trending discussions

Graph Question
Can someone tell me how to get rid of the 120.0% max on this graph? It is always going total 100% and never any more, so I would like to use more of the space for graph display purposes. I even tried reducing it so that the largest value was 99.999%, thinking maybe being exactly 100 would cause the next "level" to…
Linking Auto# Columns
I have 2 sheets that I need to link: Sheet 1 - collects user registration information through a form. Sheet 2 - I want to link some columns to copy partial data collected in sheet 1 and have it show in sheet 2. I don't want to copy the entire row, just select columns and I don't have Smartsheet Bridge. Each sheet has a…
Formulas in Reports - Any way to speed up?
Currently, I have a report connected to a single sheet. This sheet contains various formulas, including cross-sheet references. When data is added to the report, the formulas will not update/work unless the sheet is refreshed. Is there any way to have the formulas values "pop-up", or otherwise load? It is somewhat…