Disable/Read-only Field

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.

Sign in to vote!

Find more posts tagged with

Idea Submitted

Comments

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.

Quick Links

Trending ideas

Automatically Identify, Notify, and Archive Inactive Smartsheet Assets
Problem Smartsheet environments quickly become cluttered with inactive Sheets, Reports, and Dashboards that are no longer viewed or updated. This creates confusion for users and significant overhead for admins, especially in large or regulated environments. There is currently no native way to automatically identify, notify…
Auto-resizing of Calendar App
Having the ability to auto-resize the Calendar App view based on the widget size is needed. We have a "Due in 7 Days' calendar for our dashboards and would like it to be anchored at the top right. Unfortunately, as currently designed, the calendar takes up a significant amount of space and must be moved to the bottom.
Column Formula & Automation Gaps in Global Updates under Control Center
I am loving the capabilities in Global Updates under Control Center.However, there are some gaps I would really like addressed.Can we please create a Global Update option to do the following: Update a column formula not just a cell formula Update an automation Note: I know that I could create a new column and delete the…