How to Lock a Cell Based on Another in Google Sheets
resp
-
JCB40 Posted messages 3053 Registration date Status Membre Last intervention -
JCB40 Posted messages 3053 Registration date Status Membre Last intervention -
Hello, in Google Sheets (not in Excel):
I am looking for a solution to lock (neither modify / nor delete) a cell based on the value of another.
Thank you for your help..
Best regards.
I am looking for a solution to lock (neither modify / nor delete) a cell based on the value of another.
Thank you for your help..
Best regards.
1 réponse
Hello,
A sample of your file with explanations would be welcome.
To send a file,
Make sure there is NO CONFIDENTIAL DATA
you should use an attachment site like cjoint.com
Go to this site: https://www.cjoint.com/
Click on browse,
Find your file,
click on open,
Click on "Create the cjoint link",
Copy the link,
Come back here to paste it in a reply...
Best regards
A sample of your file with explanations would be welcome.
To send a file,
Make sure there is NO CONFIDENTIAL DATA
you should use an attachment site like cjoint.com
Go to this site: https://www.cjoint.com/
Click on browse,
Find your file,
click on open,
Click on "Create the cjoint link",
Copy the link,
Come back here to paste it in a reply...
Best regards
Since this is a Google Sheets file, here is a link with editing access.
https://docs.google.com/spreadsheets/d/1dPun_8OXvj9Ga_sk_IQPWrPG5oC1xa6XDSx9Ye50gtY/edit?usp=sharing
Currently, I managed with a "data validation" trick to make it so that the cells in a row can no longer be edited when the one at the end of the row is checked. However, what I don't like is that you can still easily erase the contents of the row..
Thank you in advance.
P.S.: This is a file I want to create for an association.
Best regards
A bit more explanation would be nice
1° protected file I can't do anything
2° where are the checked cells
3° protected file I can't delete anything?
Best regards