Completed

Writing a google sheets script to lock/protect rows based on value on another cell v2

Hi,

I have an expense report table that employees put their expenses. Employees have full read/write permission only to Column A,B,C,D,E,F and managers have full permission to the entire table.

I need a script that once a manager puts "approved" status on column H, the corresponding rows on column A,B,C,D,E,F should be locked for editing. In order to edit the approved cells, manager needs to change the "approved" status.

You can see the sample sheet here:

[login to view URL]

Can anybody help me on this?

Note: The freelancer should install the "working" script on the sample sheet that I have provided to get final approval.

Please also note that "data validation" method do not work, since I do not want to see the validation errors (red triangles)

Thanks in advance,

Skills: Excel, Javascript

See more: google sheets lock cells after editing, lock a cell once data is entered google sheets, conditional locking of cells in google sheets, google sheets lock conditional formatting, google sheets conditional protection, google script lock cells, google sheets read only cells, auto-lock-cells-after-data-entry google sheets, https://docs.google.com/drawings, https://docs.google.com/drawings/d, https://docs.google.com/drawings/, MS WORD , Excel, power point, flash , photo shop , Google sheets , Google forms, Writing skills , data entry , form filling , co, https://docs.google.com/, https://docs.google.com/document/d/1P91pjDiYz7TYLyZkYvKG2BLrKux4-BY8uJ8DA6MpOQI/mobilebasic, \ google sheets\ script

About the Employer:
( 10 reviews ) Istanbul, Turkey

Project ID: #17093817

Awarded to:

vladshoob

Hi there! I can write this google spreadsheet script for you. We will use onEdit trigger and custom code to prevent editing. Working on sample now. Hope to hear from you. Regards, Vladyslav.

$60 USD in 1 day
(10 Reviews)
4.3

10 freelancers are bidding on average $142 for this job

mohamedkaram93

Hi Doruk, I will be happy to help you with that. We will write a small script that will detect any changes in column H, when any cell is changed to Approved. The entire row range will be protected, such that only t More

$60 USD in 1 day
(28 Reviews)
5.0
nvbishr

please send me details..................................................................................................

$100 USD in 3 days
(20 Reviews)
5.0
ajoy3freelancer

Hi I have years experience in programming. I can use the AppScript to fulfill your requirement. I am waiting for a discussion with you. Regards Ajoy

$150 USD in 3 days
(10 Reviews)
4.5
redincorpindia

Dear client I saw your requirements regarding the Google sheet with protection of columns from users. I can develop this application within a day maximum. I developed many applications in Google sheet. I'm a profe More

$180 USD in 1 day
(8 Reviews)
4.3
ashikmahmud137

Hi, I am a professional web developer with very good skills in javascript application development. I can do this job for you. If you are interested we can discuss any details over chat. Thanks

$250 USD in 3 days
(3 Reviews)
3.1
Mokshith30

Hi I am VBA developer....expertise in web scraping &VBA macros.. I can scrape any website either static or dynamic also,,, Google apps script expert thankyou

$45 USD in 2 days
(3 Reviews)
1.7
$222 USD in 3 days
(0 Reviews)
0.0
Madhumech1107

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.

$155 USD in 2 days
(0 Reviews)
0.0
diyu98

hello i am new freelancer so my working skills are new and fresh.. but i assure that your project will be completed and give you the best result by using my excellent academic skills. thank you

$200 USD in 3 days
(0 Reviews)
0.0