USM Content
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
USM Content
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.
- Select the Sort By value (First Name by default), and select Availability.
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.
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.
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
USM Content
- In the top navigation, select Schedule.
- Select the menu icon (under My Work) to expand the menu.
- Select People. Red indicates the person is over capacity.
- 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
USM Content
By default, a work week in Resource Management is five days. The work week begins on Monday, making Saturday and Sunday nonworking days.
You can adjust the length of the work week based on your needs. For example:
- Your team could work a four-day work week for members unavailable Friday through Sunday.
- You could have some team members working every day of the week.
- Your company could consider Friday and Saturday as nonworking days and Sunday as the start of the work week.
Set your work week
- Open Account Settings.
- In Resource Management in Smartsheet, select the kebab menu in the top-right corner, then select Settings. From the list on the left, select Account Settings.
- In standalone Resource Management, select Settings > Account Settings.
- Scroll down to Time Tracking.
- Enter details for your work week in these fields:
- Work Hours in a Day
- Work Days in a Week
- Start of Work Week
- Select Save at the bottom of the page.
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 nonworking 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.
- Open Account Settings.
- From the list on the left, select Official Holidays.
- Enter the details for the holiday and select Add.
You have to add holidays one at a time.
Regional holidays
For events that affect only certain locations, create a Leave Type (for example, Regional Holiday) and assign it as needed.
- Open Account Settings.
- From the list on the left, select Leave Types.
- Enter the details for the holiday/leave type and 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.
- Select the assignment, and then select Allocation.
- Select Remove overlapping assignments.
Assign leave time to the schedule
USM Content
It's important to know who's available when you're scheduling work. Assigning leave shows blocks allocated to leave, similar to projects, so you can see conflicts.
You can set leave types and holidays for your company. Learn how to configure leave types and official holidays.
Add leave time to a person on the schedule
- In the top navigation, select Schedule.
- At the top of the left panel, select People.
- In the row for the person, select the date range for the leave.
- Select New Assignment, then search for or scroll down to the leave type you want to add and select a leave type (at the bottom of the list). The leave appears on the schedule.
By default, new assignments, including leave, appear on the schedule at 100% allocation for one week. You can select the leave to change the dates or the allocation.
You can also drag the assignment handles to adjust the duration.
Best practices and tips
Unlike holidays and weekends, Resource Management doesn't automatically subtract leave hours from availability calculations. Hours scheduled as leave are treated the same as work hours.
- Since leave isn't a project, it won't appear in the integration panel in Smartsheet. Create reports to provide a roll-up of all scheduled leaves.
- You may want to split assignments after you’ve added the leave.
Configure availability for an individual
USM Content
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:
- Open Account Settings.
- If you're working in Resource Management in Smartsheet, select the kebab menu in the top right corner, then select Account Settings.
- If you work in standalone Resource Management, select Settings > Account Settings.
- Select People.
- 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.
- Go to the People page and select Edit Profile.
- 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:
- Open the profile of the person whose availability needs adjustment by navigating to Account Settings > People.
- Select Add part-time availability in the person’s profile.
- 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:
- Navigate to Account Settings > People.
- Select Add part-time availability in the person’s profile.
- 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.
- In the Monday – Sunday boxes for this part-time block, type 0.
Resource Management will show this person is no longer available.