Customize Google Sheet as per my requirements
₹1500-12500 INR
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.
Project ID: #17203580
About the project
Awarded to:
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
12 freelancers are bidding on average ₹5562 for this job
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
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
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
I am willing to work you through this request, I will be active to get you the satisfactory Google sheet
This would be my first freelance project and look forward for positive reply. I am an expert in App Script, Formulae.