Skip to content

Overview

Using the Access on Hire2Retire you can provision and deprovision users on Smartsheet. Read the official documentation of Smartsheet here.

Smartsheet Application on Hire2Retire

Figure 1. Smartsheet Application on Hire2Retire

Define Role Definition

Provisioning Type

Define Role(s)

You can assign a Role to any user based on their AD attributes. You can define complex conditions using AND and OR logic. You can also use thee Group memberships in AD to define Roles. The Roles are used to assign licenses and roles in Smartsheet. For Example: In Figure 2, the rules are defined on the basis of Department (Equals). If the rules are passed then only user(s) will get provisioned. If no rule passes and the user(s) is present in Smartsheet then deprovisioning is performed for the user(s).

Smartsheet ScimManager Table1

Figure 2. Provision users with following rule definitions

Map the rules defined in first table with the License and Role(s) provided by Smartsheet.

  • Licenses in Smartsheet are a way to group together permissions and settings that are common to a specific role or function in an organization. Capabilities that involve creating, owning, administering, or driving a process, program, or project depends upon license in Smartsheet.

  • Roles in Smartsheet are a way to group together users who have similar responsibilities. They are typically used to define the permissions and responsibilities of a specific role in an organization, rather than the permissions and settings of a specific group of users.

Smartsheet ScimManager Table2

Figure 3. Role to License Mapping

You can also select default roles in Smartsheet. For if and only if 'SALES' Role is passed and it is not mapped in the second table then the selected default License and Role(s) in Smartsheet will be assigned to the user(s).

Smartsheet ScimManager Default Roles

Figure 4. Default Role(s) to add to rest roles

You can enable the "Do not deprovision upon change of role" checkbox to prevent users from being deprovisioned on Smartsheet due to a role mismatch.

SmartSheet ScimManager checkbox

Figure 3. Do not deprovision users upon change of role

Process All Employees

All user(s) will be provisioned on Smartsheet.

Smartsheet Process All Employees

Figure 5. Process All Employees

Provision User

You can decide to either provision or deprovision user(s) using Access.

  • Provisioning - You can provision one or more user(s) to the SmartSheet according to the requirement. User(s) can be created, updated or reactivated in provisioning operation.

  • Deprovisioning - You can deprovision one or more user(s) according to the requirement. User accounts will be deactivated on Smartsheet upon deprovisioning.

Smartsheet Form Operations

Figure 6. Configure lifecycle operations for Smartsheet

Map attributes on Smartsheet

You can select the attributes provided by Smartsheet that you want to populate. You can map values from AD/Entra ID/Hybrid to populate these attributes. You can also use Hire2Retire's powerful data transformation capabilities using Excel Style functions.

Smartsheet Form Attributes

Figure 6. Select Smartsheet attributes