Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
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.
@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
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.
Sign in to comment or add your vote.
