# Add columns

Inserts one or more columns into the sheet specified in the URL.This operation can be performed using a simple upload or a multipart upload. For more information, see Post an Attachment.

Endpoint: POST /sheets/{sheetId}/columns
Version: 2.0.0
Security: APIToken, OAuth2

## Path parameters:

  - `sheetId` (number, required)
    ID of the sheet being accessed.

## Header parameters:

  - `Authorization` (string)
    API Access Token used to authenticate requests to Smartsheet APIs.

  - `smartsheet-integration-source` (string)
    Uses the following metadata to distinguish between human-initiated API requests and third-party service-initiated calls by AI Connectors or ITSM:

- Integration source type
- Organization name
- Integration source name 

Format:


TYPE,OrgName,SourceName


Examples: 

AI,SampleOrg,My-AI-Connector-v2

SCRIPT,SampleOrg2,Accounting-updater-script

APPLICATION,SampleOrg3,SheetUpdater
    Example: "AI,SampleOrg,My-AI-Connector-v2"

  - `Content-Type` (string)
    Required for POST and PUT requests. Defines the structure for the request body.

## Request fields (application/json):

  - `title` (string)
    Column title.

  - `type` (string)
    Enum: "ABSTRACT_DATETIME", "CHECKBOX", "CONTACT_LIST", "DATE", "DATETIME", "DURATION", "MULTI_CONTACT_LIST", "MULTI_PICKLIST", "PICKLIST", "PREDECESSOR", "TEXT_NUMBER"

  - `formula` (string)
    The formula for a column, if set, for instance =data@row.

  - `hidden` (boolean)
    Indicates whether the column is hidden.

  - `index` (number)
    Column index or position. This number is zero-based.

  - `autoNumberFormat` (object)
    Object that describes how the the System Column type of "AUTO_NUMBER" is auto-generated.

  - `autoNumberFormat.fill` (string)
    Indicates zero-padding. Must be between 0 and 10 "0" (zero) characters.

  - `autoNumberFormat.prefix` (string)
    The prefix. Can include the date tokens:
  * {DD}
  * {MM}
  * {YY}
  * {YYYY}

  - `autoNumberFormat.startingNumber` (number)
    The starting number for the auto-id.

  - `autoNumberFormat.suffix` (string)
    The suffix. Can include the date tokens:
  * {DD}
  * {MM}
  * {YY}
  * {YYYY}

  - `contactOptions` (object)

  - `contactOptions.email` (string)
    A parsable email address.

  - `contactOptions.name` (string)
    Can be a user's name, display name, or free text.

  - `description` (string)
    Column description.

  - `format` (string)
    The format descriptor (see [Cell formatting](/api/smartsheet/guides/advanced-topics/cell-formatting)). Only returned if the include query string parameter contains format and this column has a non-default format applied to it.

  - `locked` (boolean)
    Indicates whether the column is locked. In a response, a value of true indicates that the column has been locked by the sheet owner or the admin.

  - `lockedForUser` (boolean)
    Indicates whether the column is locked for the requesting user. This attribute may be present in a response, but cannot be specified in a request.

  - `options` (array)

  - `symbol` (string)
    When applicable for CHECKBOX or PICKLIST column types. See [Symbol Columns](/api/smartsheet/openapi/columns).

  - `systemColumnType` (string)
    See [System Columns](/api/smartsheet/openapi/columns)
    Enum: "AUTO_NUMBER", "CREATED_BY", "CREATED_DATE", "MODIFIED_BY", "MODIFIED_DATE"

  - `validation` (boolean)
    Indicates whether validation has been enabled for the column (value = true)

  - `version` (number)
    Read only. The level of the column type. Each element in the array is set to one of the following values:
 * 0: TEXT_NUMBER, CONTACT_LIST, or PICKLIST
 * 1: MULTI_CONTACT_LIST
 * 2: MULTI_PICKLIST

See [Versioning and changes](/api/smartsheet/guides/basics/versioning-and-changes).

  - `width` (number)
    Display width of the column in pixels.

## Response 200 fields (application/json):

  - `message` (string)
    Message that indicates the outcome of the request. (One of SUCCESS or PARTIAL_SUCCESS.)
    Enum: "PARTIAL_SUCCESS", "SUCCESS"

  - `resultCode` (number)
    * '0' Success
* '3' Partial Success of Bulk Operation
    Enum: 0, 3

  - `result` (array)

  - `result.id` (number)
    Column ID.

  - `result.index` (number)
    Column index or position. This number is zero-based.

  - `result.title` (string)
    Column title.

  - `result.type` (string)
    See [Column Types](/api/smartsheet/openapi/columns)
    Enum: "ABSTRACT_DATETIME", "CHECKBOX", "CONTACT_LIST", "DATE", "DATETIME", "DURATION", "MULTI_CONTACT_LIST", "MULTI_PICKLIST", "PICKLIST", "PREDECESSOR", "TEXT_NUMBER"

  - `result.options` (array)
    Array of the options available for the column.

  - `result.validation` (boolean)
    Indicates whether validation has been enabled for the column (value = true).

  - `result.width` (number)
    Display width of the column in pixels.