Google Appscript project -- 2
$10-30 USD
货到付款
I have a sheet with multiple pages. I am trying to create a script that will allow me to setup a trigger that will:
1. Protect all sheets
2. Unprotect a specific sheet with specific cells on that sheet
The names of the sheets that will need to cycle through the unprotection feature or on "Control!B41:B54".
The specific cells that need to be unprotect on the target sheet is on "Control!J2:J60"
I want the trigger to first look at "Control!C40" and check the value of that cell. The values will be between 1 and 14 to represent the 14 cells on "Control!B41:B54". If the value on Control!C40 = 1 then it targets Control!B41 then adds 1 to Control!B41 to move it to the next sheet once the trigger is activated again. If the value on Control!C40 = 2 then it targets Control!B42 then adds 1 to Control!B41 to move it to the next sheet once the trigger is activated again. If the value on Control!C40 = 4 then it targets Control!B44 then adds 1 to Control!B41 to move it to the next sheet once the trigger is activated again.
If the value of Control!C40 = 14 then it targets Control!B54 but instead of adding 1 to Control!C40 it brings the value back to 1.
[login to view URL]
项目ID: #37671461
关于项目
授予:
I can set up the trigger to unprotect specific cells based on criteria defined in other cells. I'm a 10+ years experienced developer with expertise in Google Apps Script and Google Sheets. I can complete this task toda 更多
有5名威客正在参与此工作的竞标,均价$16/小时
Hi,. I propose a Google Apps Script solution to automate sheet protection. The script will read the value in "Control!C40" to determine the target sheet based on the specified logic. It will then protect all sheets and 更多
Hi there! As a highly-skilled freelancer with a wealth of experience in data management and entry, I guarantee efficient solutions to your Google Appscript project. My expertise spans across various platforms which in 更多
As a full-stack developer with a speciality in backend web development, automation scripts, and data warehousing, I have a comprehensive command over languages like JavaScript, Java and even Python – all of which will 更多