Skip to main content

Create Sheet

UiPath.Smartsheet.Activities.Sheets.CreateSheet

Uses the Smartsheet Create Sheet API to create a new sheet.

How it works​

The following steps are an example of how the activity works from design time (i.e., the activity dependencies and input/output properties) to run time.

  1. Complete the Setup steps.
  2. Add the Smartsheet Application Scope activity to your project.
  3. Add the Create Sheet activity inside the Smartsheet Application Scope activity.
  4. Create and enter values for the Input properties.
  5. Create and enter values for Output properties.
  6. Create and enter an ResponseStatus variable for the Output property.

In the Body of the Activity​

  • Sheet Name - The name of the new sheet. Enter a String or String variable.
  • Columns - An array of column objects to define the sheet. Enter a Column[] or Column[] variable. Either the Columns or Columns from Data properties must be provided.
  • Columns from Data - A DataTable containing the column information. Enter a DataTable or DataTable variable. Either the Columns or Columns from Data properties must be provided. Columns required are primary, title, and type.
  • Folder Id - The Folder ID to create the new sheet in. Enter a Int64 or Int64 variable. The Folder ID and Workspace ID cannot both be not null.
  • Workspace Id - The Workspace ID to create the new sheet in. Enter a Int64 or Int64 variable. The Folder ID and Workspace ID cannot both be not null.
  • Sheet - The newly copied sheet object. Enter a Sheet variable.

ResponseStatus​

The status of the request (success/failure information).

Properties​

Common​

  • DisplayName - The display name of the activity. This field supports only Strings or String variables.

Misc​

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output​

  • ResponseStatus - The status of the request (success/failure information). Enter a ResponseStatus variable.