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

Options

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.

Answers