I am fairly new to Google sheets and not a coder. I have been tasked with creating a shared sheet for recording receipts wherein User A enters the receipts in a Google sheet in Columns B:J and User B enters it in an accounting software and marks it as true in column K. Neither user has access to each other's fields of entry.

What I would like to do is once a cell is marked as true in column K, that particular row from B:J becomes locked for editing for User A.

Is this functionality possible in Google Sheets? I would be grateful for any help.

I have gone through the following link but not sure how to implement it: Auomatically lock/protect a range or row based on date

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.