Kapalı

Addon / Extension for google sheets to automate protection of cells -- 2

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

Beceriler: Uzantılar ve Eklentiler, Google Sheets, Excel Macros, Google Spreadsheets, Google App Motoru

İşveren Hakkında:
( 0 değerlendirme ) Jaipur, India

Proje NO: #32651888

Bu iş için 1 freelancer ortalamada ₹1000 teklif veriyor

aruls1962

I have made a production system which does almost the same thing as you want [login to view URL] editing some rows/some columns to some selected users [login to view URL] some columns for some/all users [login to view URL] view rights of some rows/so Daha Fazla

₹1000 INR / saat tutarından itibaren
(14 Değerlendirme)
3.9