完了済み

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 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

アワード:

jesila1525

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レビュー)
0.0

3人のフリーランサーが、このジョブに平均$41で入札しています

finecodervw

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件のレビュー)
5.4
ashusharma221995

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件のレビュー)
0.0