Anyone have success with startingNumber attribute for POST or PUT autoNumberFormat object requests?

coby ✭✭✭✭✭
edited 10/03/21 in API & Developers

I am trying to modify an a column to an AUTO_NUMBER systemColumnType. The API does NOT return an error, but rather the 'startingNumber' attribute does not actually have an effect on the sheet. I have tried both via the python sdk and also via CUrl command, I'm stumped. Anyone have any luck with this before?


#Column Update

column_spec =   smart.models.Column({


  'systemColumnType': 'AUTO_NUMBER',

  'autoNumberFormat': {'startingNumber':50, 'fill':'000000'}


# Update column

response = smart.Sheets.update_column(

{SHEET-ID},       # sheet_id

  {COLUMN-ID},       # column_id



curl{SHEET-ID}/columns/{COLUMN-ID} ^

-H "Authorization: {ACCESS TOKEN}" ^

-H "Content-Type: application/json" ^

-X PUT ^

-d "{\"index\":\"0\",\"title\":\"ROW-ID\",\"type\":\"TEXT_NUMBER\",\"systemColumnType\": \"AUTO_NUMBER\",\"autoNumberFormat\": {\"startingNumber\":\"50\", \"fill\":\"000000\"}}"


  • Hi,

    I just tested with the c# wrapper and it seems to be working :

                   new Smartsheet.Api.Models.Column
                       Id = 4810157732456324,
                       Title = "tesjthh",
                       Index = 0,
                       Type = Smartsheet.Api.Models.ColumnType.TEXT_NUMBER,
                       SystemColumnType = Smartsheet.Api.Models.SystemColumnType.AUTO_NUMBER,
                       AutoNumberFormat = new Smartsheet.Api.Models.AutoNumberFormat
                           Fill = "",
                           Prefix = "pfx",
                           StartingNumber = 200,
                           Suffix = "sfx"

    Body sent :


    Maybe try by specifing all properties (fill, prefix, starting and suffix) ?