Addon / Extension for google sheets to automate protection of cells

Closed Posted 2 years ago Paid on delivery

₹100-400 INR / hour

Closed

I need an addon / extension for google sheets to assign custom or different user rights for each cell or row / column. For eg I have a sheet of stock / inventory with columns - Product name, Quantity, Cost, Sale Price. Suppose I have 20 people on staff. I want to share that sheet with all of them but with different user rights for different people. Senior managers may view & edit all columns while sales managers may see all except Cost column but cannot edit any column except Sale Price. Similarly all other staff may only see Product name & Sale Price and edit none. (see attachment for a screenshot of this file)

I can restrict editing with protect sheet & ranges option but how can I restrict viewing of certain cells ?

Also I want to restrict editing & viewing of many cells & ranges (rows or columns) in whole workbook just by a single click and similarly unlock or un restrict file by a single click for users as specified in row no 7 & 8 of attached screenshot.

After this one I need 1 more addon and troubleshooting for google sheets , docs , etc...

Google Sheets Extensions & Additions

Project ID: #32645865

About the project

1 proposal Remote project Active 2 years ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

1 freelancer is bidding on average ₹350 for this job

GodOmori's Profile Picture
GodOmori

I've been working with programming for a long time I have a lot of experience, I can say that I'm more than suitable for this job

₹350 INR / hour
(1 Review)
0.4
Post a project like this