Tamamlanmış

Customize Google Sheet as per my requirements

Hi, I have a Google Sheet that's shared with multiple people.

I need it to be protected in a way that the users of the sheet are able to select the value from a dropdown cell in 1 row. Apart from that, the user should not be able to perform any other write operations on the sheet.

I also need the filter (and not filter views) to work on the protected sheet.

Deliverables needed for Google Sheet Shared with A User:

1.Filter Protected Cells (Single/Multiple Both). This is the default filter and not Filter Views. The default behavior in Google Sheets doesn't allow filtering on protected data.

2.Protect the entire sheet apart from a single cell/column (customizable). Disable renaming of sheet, adding sheets, hide the menu etc.

3. Create a dropdown of Column B and fix it on the sheet. In the dropdown, If "Value 1" is selected, the filter should automatically filter "Value 1" in column B. This should be customizable as well. Later on if I require a dropdown of column C instead of B, I should be able to do it.

4. Fix a Button on the sheet (which doesn't move with scrolling/filterling) and add a hyperlink to it.

All these changes should be easily replicable, as I plan to create multiple sheets with these modifications. Basic google sheet functionality like data import via URL etc. should remain intact. If there are any functionalities that we won't be able to use, inform me beforehand about the same.

Also note that values in column A and B are calculated via formula.

Beceriler: Excel, Google Chrome, Javascript, PHP, Yazılım Mimarisi

Daha fazlasını gör: google forms add-ons store, google docs add ons for education, best google sheets templates, google sheets macros, google sheets file extension, google docs plugin, google sheets automation, google sheets add ons charts, customize google calendar rss feedburner, customize google maps api marker, customize google calendar css, customize google map popup, customize google maps info window, customize google calendar rss, customize google calendar website, customize google maps pin, customize google blogger, website customize google, google ads requirements ntsc 720 480, drupal customize google map

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

Proje NO: #17203580

Seçilen:

archanaoswal

I have excellent command on Google Sheets. I have completed complex projects before. For instance - Get live cyptocurrency data and create dashboard using coinmarket API - Upload and Manage Videos in Vimeo using JS Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% INR
(53 Değerlendirme)
5.5

Bu iş için 14 freelancer ortalamada ₹5720 teklif veriyor

royalwebraisers

Hi, We can create a web based application, where you as admin can see all data and details. User will see specific column only. Also, we can export the data in excel or csv formats. In future we can enhance t Daha Fazla

in %bids___i_period_sub_35% gün içinde13333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(66 Değerlendirme)
5.9
rhodelta

30+ years Experienced Excel/Word user based in Brisbane, Australia, with office and technical background. Good with maths, spreadsheet functions, and macros. Native English speaker fluent in US and UK English. Recen Daha Fazla

in %bids___i_period_sub_35% gün içinde6111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
2.7
varyavega

Hello I have gone through your post and delighted to say that I can start working on this project right away . Having garnered years of experience and expertise in the relevant field, I am sure that I can swimmingl Daha Fazla

in %bids___i_period_sub_35% gün içinde10000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
2.1
vijayvizzu7

I read your description and i am sure i can handle your request. I worked with Google Spreadsheets and used app scripts to complete the task

in %bids___i_period_sub_35% gün içinde1750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
1.3
in %bids___i_period_sub_35% gün içinde5000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
1.4
mailjohnpaily

Hi There, I have over eight years’ experience, working in governmental and non-governmental projects. I have involved in various activities like Source to Pay, Invoice processing, Invoice verification, Payroll Verif Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde7777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
BhaviTech

Hi, I just saw your post on Linkedin and having taken the same ahead, would like to discuss the same in details, Let's discuss the same and take it ahead. The budget given here is indicative, it'll be subject Daha Fazla

in %bids___i_period_sub_35% gün içinde5555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde1500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
phuhobt

I am willing to work you through this request, I will be active to get you the satisfactory Google sheet

in %bids___i_period_sub_35% gün içinde5555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
naveenandey

This would be my first freelance project and look forward for positive reply. I am an expert in App Script, Formulae.

in %bids___i_period_sub_35% gün içinde5000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0