Google Sheets - Create Script ( Or Formula) to Lock Row upon Checkbox Tick

I need a custom scirpt ( or formula) to add on to my Google sheet. ( This script will be used on several different versions of the same sheet - if it's a formula then that's even better)

Aim: I want to lock a row from being edited once the tick box has been checked for that row.

( The tick box can be checked by any user, once the it is ticked it will mean only the owner of the sheet can edit details)

If you are aware of formulas that would work that is also fine. We have several dropdown boxes which has made conditional formatting hard so I believe creating a script is the only options but a formula would be much better.

****Please Respond with the following****

Have you created something this is before?

Do you think it can be done with formulas? Or will you need a script?

How long will the task take you?

Only candidates that respond with the above will be considered

Навички: Google Sheets, Excel, Excel VBA

Деталі: create script google, example create script google provisioning api, create macro or formula to calculate quantity of patterns along a row of numbers, google sheets checkbox script, google sheets uncheck all checkboxes, google sheets checkbox conditional formatting, google sheets sumif checkbox, google sheets checkbox timestamp, google sheets radio button, checkbox in google docs, google sheets checkbox formula, (google AND (spreadsheets OR (apps AND script) OR forms OR sheets OR docs)) OR (PHP AND (integrate OR integration OR CRM AND or , google sheets sort script, google sheets find and replace formula, google sheets run script, google sheets refresh script, google sheets recalculate script, google sheets timestamp script, google sheets run script on click, google sheets automatically add formula to new row

Про роботодавця:
( 4 відгуки(-ів) ) Melbourne, Australia

ID Проекту: #25640905



Hello, I can understand your needs and I'm sure the Data Validation option available in Google sheets would satisfy your needs. I have experience working with this feature earlier and it would just take me few hours t Більше

$20 AUD за 2 дні(-в)
(0 відгуків(-и))

3 фрілансерів(-и) готові виконати цю роботу у середньому за $41


Hi, Please find response below Have you created something this is before? >> I have done locking of rows, and I believe the same concept would have to be applied. Do you think it can be done with formulas? Or will yo Більше

$75 AUD за 3 дні(-в)
(42 відгуків(и))

Dear sir/madam, I am offering my services on short notice. Relevant Skills and Experience Please consider me and give me a chance to impress you by my quality services

$27 AUD за 5 дні(-в)
(0 відгуків(и))