CreateSheet
Create a new sheet in Smartsheet for data organization and tracking.
Note: This procedure makes use of indexed parameters. Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.
Suppose there is an input parameter named Param#. To input multiple instances of an indexed parameter like this, execute:
EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"
In the table below, indexed parameters are denoted with a '#' character at the end of their names.
Input
| Name | Type | Required | Description |
| SheetName | String | True | The name of the new sheet to be created. This should be a unique, user-friendly identifier for the sheet. |
| ColumnName# | String | False | The name of the column to be added to the sheet. Use descriptive names for clarity. |
| ColumnType# | String | False | The data type of the column values, such as Text, Number, or Date, which defines how the column data will be stored and validated. |
| PrimaryColumn# | String | False | Indicates whether the specified column is the primary column, which typically serves as the main identifier for rows in the sheet. |
Result Set Columns
| Name | Type | Description |
| Success | String | A boolean or status flag indicating if the sheet creation operation was successful. |
| Id | String | The unique identifier of the sheet created. |