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.
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
Bu iş için 14 freelancer ortalamada ₹5720 teklif veriyor
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
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
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
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 Daha Fazla
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
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.