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,
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.
10 freelancers are bidding on average $142 for this job
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
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
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