ShareSheet
Shares a sheet with a user or group in your Smartsheet account.
Stored Procedure-Specific Information
To execute this procedure, enter:EXEC ShareSheet SheetId='8449165781585796', UserEmail='[email protected]', AccessLevel='EDITOR', SendEmail='true', CcMe='true', EmailSubject='Sharing this sheet with you', EmailMessage='You can find the shared sheet below.'
Input
| Name | Type | Required | Description |
| SheetId | String | True | The unique identifier of the sheet being shared. |
| UserEmail | String | False | The email of the user to share the sheet with. |
| GroupId | String | False | The unique identifier of the group to share the sheet with. |
| AccessLevel | String | True | The access level for the user or group on the shared sheet.
The allowed values are ADMIN, COMMENTER, EDITOR, EDITOR_SHARE, OWNER, VIEWER. |
| SendEmail | Boolean | False | Boolean value indicating whether to notify the user or group about the shared sheet with an email. |
| CcMe | Boolean | False | Boolean value indicating whether to send a copy of the email to the sharer of the sheet. Applies only when 'SendEmail' is set to true. |
| EmailSubject | String | False | The subject of the email for the shared sheet. Applies only when 'SendEmail' is set to true. |
| EmailMessage | String | False | The message of the email for the shared sheet. Applies only when 'SendEmail' is set to true. |
Result Set Columns
| Name | Type | Description |
| Success | Boolean | A boolean value indicating whether the operation was successful. Returns 'true' if the sheet was shared successfully, and 'false' otherwise. |
| Id | String | The unique identifier of the created sheet share. |