Customize Google Sheet as per my requirements

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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.

Excel Google Chrome JavaScript PHP Software Architecture

Project ID: #17203580

About the project

12 proposals Remote project Active 5 years ago

Awarded to:

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 More

₹5000 INR in 1 day
(103 Reviews)
6.0

12 freelancers are bidding on average ₹5562 for this job

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 More

₹13333 INR in 3 days
(136 Reviews)
6.6
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

₹1750 INR in 3 days
(9 Reviews)
4.1
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 More

₹6111 INR in 2 days
(5 Reviews)
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 More

₹10000 INR in 3 days
(7 Reviews)
3.3
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 More

₹1750 INR in 1 day
(0 Reviews)
0.0
phuhobt

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

₹5555 INR in 2 days
(0 Reviews)
0.0
naveenandey

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

₹5000 INR in 3 days
(0 Reviews)
0.0