Multi select column via API shows as a TEXT_NUMBER type


I am trying to update the options in a multi select column via API but if fails with

1|bot | [Smartsheet] 2020-06-18T11:12:30.360Z[ ERROR] Request failed after 0 retries

1|bot  | [Smartsheet] 2020-06-18T11:12:30.361Z[  ERROR] PUT

1|bot | [Smartsheet] 2020-06-18T11:12:30.361Z[ ERROR] Response: Failure (HTTP 400)

1|bot |    Error Code: 1060 - Column options are not allowed for column type TEXT_NUMBER.

1|bot |    Ref ID: 1l5wo01sjzakv

When I retrieve the column it is defined as a TEXT_NUMBER in the API return:


"id": xxxxxxxxxxxxxxxxxxxxxxxx,

"version": 2,

"index": 70,

"title": "Non-Core Products",

"type": "TEXT_NUMBER",

"options": [

"vCD 9.x",

"vCD 10.x",












"Workspace ONE",



"VMC on AWS",



"validation": true,

"width": 150


Best Answer