Add Columns to Sheet
smartsheet_add_columnsAdd one or more columns to a Smartsheet sheet by specifying title, type, optional index, dropdown options for picklists, and width.
Instructions
Add one or more new columns to a Smartsheet sheet. Supported column types: TEXT_NUMBER, DATE, DATETIME, PICKLIST, CHECKBOX, CONTACT_LIST, DURATION, PREDECESSOR, AUTO_NUMBER, ABSTRACT_DATETIME. Picklist/dropdown columns require an 'options' array.
Args:
sheet_id (number): Target sheet ID
columns (array): Column definitions, each with:
title (string): Column header text
type (string): Column type (TEXT_NUMBER, DATE, PICKLIST, CHECKBOX, CONTACT_LIST, etc.)
index (number, optional): 0-based position; appends if omitted
options (string[], optional): Dropdown options for PICKLIST columns
width (number, optional): Column width in pixels
Returns: Created column definitions with assigned IDs.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_id | Yes | ||
| columns | Yes |