Manpower Tracking with Projects

I am trying to set up a way to track manpower 50+ people plus projects that are ongoing.

2 separate sheets are fine - 1 project summary and 1 manpower.

How can i set it up, that i can see who is available, when workers will be on vacation and it will notify is someone is booked for one project so i can't double book them.

Newer to smart sheet, limited on the Resource and Dashboard capabilities.

Find more posts tagged with

Human Resources

Construction

Gantt View

Project Management

Groups and Group Management

Comments

Richard Rymill SBP

Hi Kelcon

This link to help pages in Smartsheet which will guide you on the process.

https://help.smartsheet.com/articles/2026109-resource-management-overview

What you can do is enable Resource planning on the sheets where that matters and then in the Resource viewer area you can see a roll up of a combo of holidays and projects. This is really powerful for planning.

You can also organise your Viewing of Resources in Teams or Geographic areas.

We can share a "Setting up Resource planning To Do List Smartsheet" with you, which will give you a Blow by Blow set of actions. If you would like that, email me and I will share?

We are a consultancy org ,so if your company can find some budget for us to work with you on this we can get you up and running nice and quickly if not this forum is excellent.

For example our packages start @ $2000 USD for which you get one to one mentoring with one of our top Gurus for 12 hours plus a workflow set of suitable sheets you can modify to suit your needs and implement quickly. We have these for pretty much every usage type and a Free 1 hour demo consultation if needed.

Hope that helps.

RichardR

Kelcon

Thanks Richard, I will work with the Resource sheet and get more skilled with that. Thanks for the offer on the training.

Sign in to join the conversation!

Quick Links

Trending discussions

Reference links break in formula
I want a formula that can reference updates on another sheet and add the info onto my sheet. The other sheet is a schedule that has job locations and PTO time for each individual on each day of the week. I want to know the dates that each individual on the sheet has an upcoming PTO, and for my sheet to update with 'PTO' on…
Can I remove "Select All" from Dropdown (Multi Select) form fields?
I have two Dropdown selectors in a form. Both need to allow users to select multiple options, but NEVER allow ALL options to be selected. At the top of the lists is a "Select All" options checkbox. I don't see any way to remove it in the form setup. I would expect it to be an optional feature that I could toggle on if I…
Smartsheet access
A collogue of mine had been using Smartsheet and is no longer with the Org. Im the administrator and can't find where the timelines and Gaant charts are. Is there someone at Smartsheet who could help me?