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

SherryFox

This would be a gamechanger on Forms. Allowing users to SEE previous results and have them determine if they need to provide an update on the form itself. We use the forms for as much as possible.