Disable/Read-only Field

optimusprime123

Would be great if we could set certain fields to disable or read-only input fields instead of just having the option to hide them.

Erin Horiuchi Green

@optimusprime123

Only the Smartsheet Owner and Admin Access can edit a locked field. Smartsheet Edit Access cannot edit a locked field.

Depending on the volume of your Smartsheet Columns targeted to be Locked, it is quicker tp update either manual or API.

I use the API since I have several Smartsheets with a large volume of Locked Columns.

Get Smartsheet Columns and ID

import smartsheet
smartsheet_client = smartsheet.Smartsheet('INSERT TOKEN')
action = smartsheet_client.Sheets.get_columns(INSERT SMARTSHEET ID, )
columns = action.data
for col in columns:
print(col.title)
print(col.id)

Update Smartsheet Columns to Locked (*Can be further updated by creating a Column List and running a loop to Lock*)

import smartsheet
import smartsheet.models
smartsheet_client = smartsheet.Smartsheet('INSERT TOKEN')
column_spec = smartsheet.models.Column ({
'locked':true
})
response = smartsheet_client.Sheets.update_column( INSERT SMARTSHEET ID, INSERT COLUMN ID, column_spec)
updated_column = response.result