Resource availability

Who can use this?

Plans:

  • Resource Management

The schedule allows you to sort by availability and view the allocation heatmap which distills project assignments into a person’s utilization. Read more on how to get an accurate understanding of your team’s availability on the schedule in Resource Management by Smartsheet.

Sort by availability in the schedule view

Who can use this?

Plans:

  • Resource Management

You can sort or filter the schedule to see when people are available and find specific roles or skills your projects need. 

Sort by availability to start with the person who's most available to work. Next, choose filters for time frame, project types, roles, and more to see who on your team can complete work with specific criteria. For example, use the Time Frame, Project Type, and Display filters to see who can work on a priority billable project. 

  1. Select the Sort By value (First Name by default), and select Availability.
  2. Select the Time Frame value, and then select a predefined time frame or a custom date range.

    The blue highlight on the schedule shows the time frame. 

Brandfolder Image
sort by availability

 

  1. Select the Project Type value, and then select the Confirmed check box.

    Using this filter temporarily recalculates your team's utilization and displays internal and tentative project assignments as gray.

  2. Select the Display value, and then select the skills required for the work you need to assign.

    You have a list of people matching your criteria in order from most available to least available.

View allocation heatmap

Who can use this?

Plans:

  • Resource Management

Permissions:

Resourcing Administrators, Portfolio Editors, People Schedulers, Portfolio Reporters, Portfolio Viewers, Project Editors

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

  1. In the top navigation, select Schedule
  2. Select the menu icon (under My Work) to expand the menu.
  3. Select People. Red indicates the person is over capacity. 
Brandfolder Image
allocation heatmap detailed view
  1. Use the up or down carat to expand or collapse a person's schedule details.

Availability, over-allocation, and the allocation heatmap are only shown for up to 60 days in the past.

See allocation for only one person

On the left sidebar, under People Filters, select Team Member and then clear the checkboxes from all other names.

If a Team Member's allocation doesn't appear, add a start date in their profile.

Configure holidays and weekends

Who can use this?

Plans:

  • Resource Management

Permissions:

  • Resourcing Administrator
  • Portfolio Editor

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

By default, a work week in Resource Management is five days. The work week begins on Monday, making Saturday and Sunday nonworking days.

Your team could work a four-day workweek for members unavailable Friday through Sunday, or you could have some team members working every day of the week. Some companies consider Friday and Saturday as nonworking days and Sunday as the start of the work week. You can adjust the length of the work week based on your needs.

This image shows the adjustable settings for the length of a work week

Set your work week

  1. Open Account Settings.
    1. If you are working in Resource Management in Smartsheet, select the kebab menu in the top right corner, then select Account Settings.
    2. If you work in standalone Resource Management, select SettingsAccount Settings.
  2. Scroll down to Time Tracking
  3. Enter details for your work week in these fields:
    • Work Hours in a Day 
    • Work Days in a Week 
    • Start of Work Week
  4. Select Save

On the Schedule page, nonworking days appear as light gray vertical bands. Resource Management doesn’t include nonworking days (official holidays or weekends) in availability calculations.


Manage holidays 

Official holidays 

Official holidays occur at all locations and appear as non-working days.

Before you begin

Part-time availability takes priority over official holidays. For example, if you work with a part-time employee whose schedule falls on an official holiday(s), the worker appears as available on the holiday. 

To make the part-time employee appear unavailable on an official holiday, remove their part-time availability schedule on that day.

  1. Open Account Settings.
  2. On the left menu, select Official Holidays
  3. Enter the details for the holiday.
  4. Select Add

You have to add holidays one at a time. You can not add them in bulk. 

Regional holidays

For events that affect only certain locations, create a Leave Type (for example, Regional Holiday) and assign it as needed.

  1. Open Account Settings.
  2. On the left menu, select Leave Types.
  3. Enter the details for the holiday/leave type.
  4. Select Add. Once you add a new leave, it appears as an Assignment option. 

Workdays with leaves aren’t automatically subtracted from the budget. Any time dedicated to Leave is considered available time.

Remove project assignments that overlap with regional holidays

You can’t undo the removal of overlapping assignments. Double-check your schedule before you make this change.

  1. Select the assignment, and then select Allocation.
  2. Select Remove overlapping assignments.

Assign leave time to the schedule

Who can use this?

Plans:

  • Resource Management

Permissions:

Resourcing Administrators, Portfolio Editors, and People Schedulers can assign leave time to the schedule.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

To add leave time to a person on the schedule:

  1. Select the People view of the schedule. 
  2. Select the row and in the date range where you want to add the leave. 
  3. Select New Assignment, then search for or scroll down to the leave type you want to add. 
  4. Select a leave type from the bottom of the list. The leave will appear on the schedule. 

By default, new assignments, including leave, appear on the schedule at 100% allocation for one week.

  • Drag the assignment handles to adjust the duration. You can also adjust the duration by selecting the leave and manually change the dates
  • Select the leave to adjust the allocation.

Unlike holidays and weekends, Resource Management does not automatically subtract leave hours from availability calculations. Hours scheduled as leave are treated just like work hours.

You may want to split assignments after you’ve added the leave.

Leave is only visible on the schedule, and it resembles a project. Since it is not a project though, it will not come through the integration panel in Smartsheet. Outside of the schedule tab, you can create reports to get a roll-up of all of leave resources are taking.

 

Configure availability for an individual

Who can use this?

Plans:

  • Resource Management

Permissions:

  • Resourcing Administrator

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

The default work week for your organization is set on the Account Settings page. This default work week informs the allocation % target on the schedule so you can schedule your team for 100% of their available time. For example, 40 hours a week would be 100% allocation.

Set availability for a specific person:

  1. Open Account Settings.
    1. If you're working in Resource Management in Smartsheet, select the kebab menu in the top right corner, then select Account Settings.
    2. If you work in standalone Resource Management, select SettingsAccount Settings.
  2. Select People.
  3. Select the individual's name and make adjustments in the Availability section.

Only assignments created or modified after you set the part-time availability setting are affected; you may need to modify existing assignments to reflect updated availability . Prior assignments will still show full-time availability. 

If a person has zero hours available on any given day, that day is considered a non-working day. Assignments that overlap with a non-working day are removed from timesheet suggestions and do not count towards the project budget in reports

Time suggestions (unconfirmed hours) will not be scheduled if someone is unavailable.


Set first and last days of work

Team members are considered unavailable before their first day of work and after their last day of work. 

  1. Go to the People page and select Edit Profile
  2. In the Availability section, enter the first and last day of work. 

Set permanent part-time availability

For people who have availability that differs from the default settings: 

  1. Open the profile of the person whose availability needs adjustment by navigating to Account Settings > People.
  2. Select Add part-time availability in the person’s profile.
  3. In the Start Date and End Date boxes, set the dates: enter the start and end dates to indicate when the working duration will differ from the default work week for your organization. 

If the individual will have part-time availability for an indefinite amount of time, leave the End Date box empty.

Set temporary part-time availability

If a person is temporarily unavailable during a specific period, set a part-time availability block in their profile:

  1. Navigate to Account Settings > People.
  2. Select Add part-time availability in the person’s profile.
  3. In the Start Date box, select the first day you want them to show as unavailable, and in the End Date box, select the last day they will be unavailable. 
  4. In the Monday – Sunday boxes for this part-time block, type 0.

Resource Management will show this person is no longer available.