Block non-working days for resources?

Hello! I'm trying to schedule around vacation dates and other non-working days per resource, not for the whole team or whole sheet. How can I block off non-working days for a particular person without doing it 'manually' and messing up the dependencies?

Thanks for any guidance!

Find more posts tagged with

Non-profit

Healthcare

Education

Product Development

Comments

Robert Poddar

Hi mdcatlett

Currently there isn't any option in Smartsheet to mark non-working days at a resource level. This has been a request from the users, but as of now, there isn't any visibility as to when Smartsheet will have this feature.

The only workaround (which is not the best/cleanest) is to increase the duration of the task and make a note that the resource was on PTO, so that you know the reason of the shift in the plan.

I feel that this is a critical feature for any project planning software, but not sure why Smartsheet doesn't think so..

Chris McKay

Hi mdcatlett,

This is currently not possible in Smartsheet. Unless you want to create an enormously complex web of hidden columns and formulas, the easiest way to do this is to setup another control sheet with each resource name (as a Contact column) and a Start and End date for non-working periods.

Then in your project plan, you'll want to create a validation column that checks whether the resource assigned to a task row has a non-working period specified in your control sheet that falls within the task date range. The formula might look something like this:

=IF(OR(COUNTIFS({Resource Range}, [Assigned To]@row, {Resource Start}, >=Start@row, {Resource End}, <=Finish@row) > 0, COUNTIFS({Resource Range}, [Assigned To]@row, {Resource Start}, <=Start@row, {Resource End}, >=Finish@row) > 0), "Unavailable", "Available")

You could then use conditional formatting to format the row (e.g. red background) when an "Unavailable" period has been selected.

Not ideal I know and the above formula is tough for newbies to understand, but quite frankly if Smartsheet doesn't allow us to even assign multiple resources to a task, I wouldn't put much hope in the overall resource management piece.

Hope this helps.

Kind regards,

Chris McKay

Sign in to join the conversation!

Quick Links

Trending discussions

How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…