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 see the current vote count, add your own vote, or leave a comment.
@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.
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
Be able to print and/or export Workflow Automations in PDF and/or export to Visio. this would be used for document control and troubleshooting aid
It would be beneficial to be able to leverage Smartsheet Automations to make REST API calls. This has many potential use cases, but one I could see is adding users to Smartsheet groups when the are added to a 'roster sheet' in Smartsheet. It would allow us to use the full power of Smartsheet's API within easy to use…
