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

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…