Skip to main content
Glama
christianclaudio

mcp-server-smartsheet-rm

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
SMARTSHEET_RM_PROFILENoTool profile subset: time, projects, admin, fullfull
SMARTSHEET_RM_BASE_URLNoBase API URLhttps://api.rm.smartsheet.com/api/v1
SMARTSHEET_RM_READONLYNoSet to 1 to restrict server to read-only tools0
SMARTSHEET_RM_API_TOKENYesSmartsheet RM (10,000ft) API Token (Required)
SMARTSHEET_RM_LOG_FORMATNoSet to json for Datadog/CloudWatch structured logstext
SMARTSHEET_RM_ALLOW_BULK_DESTRUCTIVENoSet to 1 to unlock bulk delete operations0

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": true
}
logging
{}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}

Tools

Functions exposed to the LLM to take actions

NameDescription
time_list_time_entriesB

List time entries across organization or filtered by project, user, or date range (YYYY-MM-DD).

time_get_time_entryB

Get details for a specific time entry by its ID.

time_create_time_entryC

Create a new time entry for a user on a project (date format: YYYY-MM-DD).

time_update_time_entryC

Update an existing time entry.

time_delete_time_entryA

Delete a time entry (Destructive: requires confirm=True).

time_list_user_suggestionsB

Read unconfirmed scheduled time suggestions for a user.

time_update_time_approval_statusC

Approve or reject time entries for a user (status: 'approved', 'rejected', 'pending').

time_lock_timesheetB

Lock or unlock timesheet records for a user up to a specified lock date (YYYY-MM-DD).

time_fill_weekly_timesheetB

Batch-fill weekly timesheet entries (Mon-Fri 8h default, or 7-day with include_weekends=True) for a user.

start_date: Monday date of the week in YYYY-MM-DD. include_weekends: When True, logs Saturday and Sunday entries as well. weekend_hours: Specific hours for Saturday/Sunday (defaults to daily_hours if omitted).

time_confirm_suggested_hoursA

Auto-confirm all unconfirmed scheduled suggestions for a user within a date range.

time_reconcile_and_submit_weekB

Audit weekly logged hours against a target (40h) and optionally submit/approve timesheet.

time_list_approvalsB

List submitted time entry and expense approvals across the organization.

time_create_approvalC

Submit or approve approvable records (approvable_type: 'time_entries' or 'expense_items').

time_delete_approvalA

Delete a pending approval record (Destructive: requires confirm=True).

projects_list_projectsC

List projects in Smartsheet RM with filtering, phase inclusion, and pagination.

projects_get_projectB

Get project details including budget, phases, client, and dates.

projects_create_projectC

Create a new project in Smartsheet RM.

projects_update_projectC

Update project metadata, state, dates, budget or archive status.

projects_delete_projectA

Delete a project (Destructive: requires confirm=True).

projects_list_project_usersB

List users associated with or assigned to a specific project.

projects_list_project_phasesC

List phases belonging to a project.

projects_get_project_phaseC

Get details for a specific project phase.

projects_create_project_phaseC

Create a new phase under a project.

projects_update_project_phaseC

Update an existing project phase.

projects_delete_project_phaseA

Delete a project phase (Destructive: requires confirm=True).

projects_list_assignmentsC

List resource scheduling assignments across projects or filtered by user/project.

projects_get_assignmentC

Get details for a specific assignment.

projects_create_assignmentC

Create a resource assignment on a project or phase (dates: YYYY-MM-DD).

projects_update_assignmentC

Update dates, allocation percentage, or hours on an existing assignment.

projects_delete_assignmentA

Delete a resource assignment (Destructive: requires confirm=True).

projects_clone_project_scheduleB

Duplicate project budget settings, timeline, and phase milestone structure to a new project.

projects_list_status_optionsA

List account-level assignment work status options.

projects_list_placeholder_resourcesC

List placeholder resources used for forecasting and capacity modeling.

projects_create_placeholder_resourceD

Create a placeholder resource.

projects_delete_placeholder_resourceB

Delete a placeholder resource (Destructive: requires confirm=True).

projects_list_assignment_subtasksB

List subtasks (checklist tasks) for a project assignment.

projects_create_assignment_subtaskC

Create a subtask under a project assignment.

projects_delete_assignment_subtaskB

Delete an assignment subtask (Destructive: requires confirm=True).

admin_list_usersB

List users in the organization with role/discipline filtering.

admin_get_userC

Get details for a specific user.

admin_create_userC

Create a new user profile in Smartsheet RM.

admin_update_userC

Update a user's profile, role, discipline, bill rate, or archive state.

admin_delete_userB

Delete or archive a user (Destructive: requires confirm=True).

admin_list_user_bill_ratesB

List bill rate tiers for a user.

admin_create_user_bill_rateB

Add a bill rate tier with an effective date range for a user.

admin_get_user_availabilityC

Query scheduled hours vs available capacity for a user.

admin_get_user_utilizationB

Get billable utilization metrics for a user.

admin_list_rolesB

List all configured user roles.

admin_create_roleC

Create a new role.

admin_update_roleC

Update an existing role.

admin_delete_roleA

Delete a role (Destructive: requires confirm=True).

admin_list_disciplinesA

List all configured disciplines.

admin_create_disciplineC

Create a new discipline.

admin_update_disciplineC

Update an existing discipline.

admin_delete_disciplineA

Delete a discipline (Destructive: requires confirm=True).

admin_list_clientsD

List clients.

admin_get_clientC

Get details for a specific client.

admin_create_clientC

Create a new client record.

admin_update_clientD

Update a client record.

admin_delete_clientB

Delete a client record (Destructive: requires confirm=True).

admin_list_client_contactsC

List contacts associated with a client.

admin_create_client_contactC

Add a contact for a client.

admin_delete_client_contactB

Delete a client contact (Destructive: requires confirm=True).

admin_list_leave_typesA

List leave types (e.g. Vacation, Sick, Parental, PTO).

admin_get_leave_typeC

Get details for a specific leave type.

admin_create_leave_typeC

Create a new leave type.

admin_update_leave_typeC

Update a leave type name.

admin_delete_leave_typeA

Delete a leave type (Destructive: requires confirm=True).

admin_list_holidaysB

List company and regional holidays.

admin_get_holidayC

Get details for a specific holiday.

admin_create_holidayC

Create a new company holiday or non-working day.

admin_update_holidayC

Update a holiday.

admin_delete_holidayB

Delete a holiday (Destructive: requires confirm=True).

admin_list_expensesB

List logged expenses across projects or filtered by project/user.

admin_get_expenseB

Get details for a specific logged expense.

admin_create_expenseC

Log a project expense item.

admin_update_expenseC

Update a logged expense item.

admin_delete_expenseA

Delete an expense item (Destructive: requires confirm=True).

admin_list_expense_categoriesB

List configured expense categories.

admin_create_expense_categoryC

Create an expense category.

admin_delete_expense_categoryA

Delete an expense category (Destructive: requires confirm=True).

admin_list_tagsC

List tags.

admin_create_tagD

Create a tag.

admin_delete_tagB

Delete a tag (Destructive: requires confirm=True).

admin_list_custom_fieldsB

List custom field definitions.

admin_get_custom_fieldC

Get details of a custom field definition.

admin_create_custom_fieldA

Create a custom field definition (field_type: text, number, select, date; target_type: Project, User, Phase).

admin_update_custom_fieldC

Update a custom field definition.

admin_delete_custom_fieldA

Delete a custom field definition (Destructive: requires confirm=True).

admin_list_custom_field_valuesC

List custom field values for a specific entity.

admin_set_custom_field_valuesC

Set custom field values for an entity.

admin_get_user_statusesB

Retrieve work status history for a specific user (ITO, WFH, SIC, OOO, VAC, OOF).

admin_set_user_statusB

Set current working status for a user (status: 'ITO', 'WFH', 'SIC', 'OOO', 'VAC', 'OOF').

admin_get_report_rowsC

Generate detailed custom report rows.

admin_get_report_totalsC

Generate aggregated custom report totals.

admin_list_webhooksB

List configured organization webhooks.

admin_create_webhookC

Register a webhook subscription (e.g. 'time.entry.created', 'project.updated', 'assignment.created').

admin_delete_webhookA

Delete a webhook subscription (Destructive: requires confirm=True).

Prompts

Interactive templates invoked by user choice

NameDescription
time_timesheet_reconciliationAudit and reconcile weekly timesheets against 40-hour capacity target.
projects_project_staffing_planAnalyze resource assignments and phase timelines for a project.

Resources

Contextual data attached and managed by the client

NameDescription
rm_capabilities_resourceResource documentation detailing Smartsheet Resource Management capabilities.
rm_quickstart_resourceQuickstart guide for Smartsheet Resource Management MCP operations.

TDQS

C2.6/5.0

Scored across 98 tools

Disambiguation4/5

Tools are largely distinct by resource and action, but overlaps exist (e.g., time_create_approval and time_update_time_approval_status both manage time entry approvals; timesheet tools like fill/confirm/reconcile could be confused). With 98 tools, minor ambiguity is inevitable, but descriptions generally help.

Naming Consistency4/5

Consistent snake_case with a clear prefix_action pattern (time_, projects_, admin_). Minor deviations like 'set' vs 'update' and plural/singular inconsistencies (user_statuses vs user_status) slightly reduce predictability.

Tool Count1/5

98 tools is extreme over-provisioning for any single server. Even for a complex RM domain, this count is a usability hazard, far exceeding the 15-tool guideline.

Completeness4/5

Broad coverage of projects, time, and admin entities, including CRUD for most resources and special operations. Minor gaps like missing update for tags, expense categories, and client contacts, but overall surface is comprehensive.

Maintenance

ActivityActive
ResponsivenessNo issues