Sign in

v1

latestOpenAPI 3.0.32026-08-061874701.5 MB
sheetSummary

Add summary fields

Creates one or more summary fields for the specified sheet.

post/sheets/{sheetId}/summary/fields

Query parameters

renameIfConflictboolean

Set to true if you want to override the requirement for unique summary field names. Repeated names will be adjusted by appending "(1)" or similar after the field name.

Request body

formatstring

The format descriptor. Only returned if the include query string parameter contains format and this column has a non-default format applied to it.

formulastring

The formula for a cell, if set.

indexnumber

Field index or position. This number is zero-based.

lockedboolean

Indicates whether the field is locked.

optionsstring[]

When applicable for PICKLIST column type. Array of the options available for the field.

symbolstring

When applicable for PICKLIST column type.

titlestring

Arbitrary name, must be unique within summary.

type'ABSTRACT_DATETIME' | 'CHECKBOX' | 'CONTACT_LIST' | 'DATE' | 'DATETIME' | 'DURATION' | 'MULTI_CONTACT_LIST' | 'MULTI_PICKLIST' | 'PICKLIST' | 'PREDECESSOR' | 'TEXT_NUMBER'
validationboolean

Indicates whether summary field values are restricted to the type.

Example request

[
  {
    "contactOptions": [
      {
        "email": "jane.doe@smartsheet.com",
        "name": "Jane Doe"
      },
      {
        "email": "john.doe@company.com",
        "name": "John Doe"
      }
    ],
    "objectValue": {
      "objectType": "CONTACT",
      "email": "john.doe@acme.com",
      "name": "John Doe",
      "imageId": "1234!_qwer!_5667zxcvQWER!_ASDF",
      "emailId": "23456789",
      "userId": "12345678",
      "lookUpName": true
    }
  }
]

Response

OK

message'PARTIAL_SUCCESS' | 'SUCCESS'

Message that indicates the outcome of the request. (One of SUCCESS or PARTIAL_SUCCESS.)

resultCode0 | 3
  • '0' Success
  • '3' Partial Success of Bulk Operation
versionnumber nullable

New version of the sheet. Applicable only for operations which update sheet data.

Example response

{
  "message": "SUCCESS",
  "result": [
    {
      "createdBy": {
        "email": "jane.doe@smartsheet.com",
        "name": "Jane Doe"
      },
      "modifiedBy": {
        "email": "jane.doe@smartsheet.com",
        "name": "Jane Doe"
      },
      "objectValue": {
        "objectType": "CONTACT",
        "email": "john.doe@acme.com",
        "name": "John Doe",
        "imageId": "1234!_qwer!_5667zxcvQWER!_ASDF",
        "emailId": "23456789",
        "userId": "12345678",
        "lookUpName": true
      }
    }
  ]
}