startingNumber ignored?

JodyRakow

I appear to be having the same issue as described in this post from 2021.

PUT

{
"type": "TEXT_NUMBER",
"systemColumnType": "AUTO_NUMBER",
"index": 1,
"title": "Auto",
"autoNumberFormat": {
"prefix": "10",
"fill": "000",
"startingNumber": 1,
"suffix": ""
}
}

is returning

{ "message": "SUCCESS", "resultCode": 0, "version": 245, "result": { "id": 975110288920452, "index": 1, "systemColumnType": "AUTO_NUMBER", "title": "Auto", "type": "TEXT_NUMBER", "validation": false, "width": 115, "autoNumberFormat": { "prefix": "10", "fill": "000", "suffix": "" } }}

The starting number isn't referenced when I use the GET operation either.

Any advice or solutions would be warmly welcomed!

Isaac A.

Hi @JodyRakow!

I’m not an expert in the API myself, but after testing your code using Postman, it seems to work just fine. Due to the nature of the auto-number column, changing the column properties, such as startingNumber, won’t affect values that have already been generated. That new starting number will only apply to rows created after the change, and you should see it reflected in the column properties as well.

If your expectation is that all rows start from that new number, then yes, you might need to recreate the column, as explained in this Help Center article:
👉 Reset the Auto-Number Column

As for the second part of your question, where the startingNumber doesn’t appear in the response from the GET /columns call, this does seem unexpected to me based on what’s documented. For further clarity, I’d recommend reaching out to Smartsheet Support directly so they can help investigate this through a private channel:
👉 Contact Support

Hope this helps!

Cheers,
Isaac.