Update Request: Is there a way to prevent text from being edited in locked columns?
You can edit entries for columns that have been locked in the update request. Is there a way to prevent this information from being edited?
Best Answer
-
what about creating a dummy column that copies the text from the locked column and you select the dummy one in the update request ? and you just hide the dummy column in the sheet (or push it to the right) so it does not bother you
this looks like this by me, assuming I understood your case
Answers
-
hi,
yeah just remove them from the form or hide them
-
@florian.zbinden7 , No I want them to be included as they give essential information (Action Item) to the responder.
-
what about creating a dummy column that copies the text from the locked column and you select the dummy one in the update request ? and you just hide the dummy column in the sheet (or push it to the right) so it does not bother you
this looks like this by me, assuming I understood your case
-
@florian.zbinden7 Thank you this works, still a bandaid, but works.
