Any way to lock columns, but still be able to edit via Update Request?

gardn415

We have an issue where users can edit certain columns in the sheet, and it has an affect on workflows, etc. We want a way to be able to lock certain columns so they can't be edited in the sheet itself. They do still need to be able to edit other columns, so we can't make them just 'viewers'.

However, locking columns also locks these fields for edit in Update Request as well, which is not what we want. Is there any way to 'lock down' the sheet but not the Update Requests? It seems like no, but I wasn't sure if anybody found a work around for this.

Joe Goetschel

Do you have a dynamic view?

gardn415

We do not.