+ Reply to Thread
Results 1 to 2 of 2

Create a second sheet that user can filter/search to mirror a protected sheet

  1. 06-02-2023, 03:50 PM #1
    Kybersoze
    Kybersoze is offline
    Registered User
    Join Date
    06-02-2023
    Location
    California
    MS-Off Ver
    Google Sheets
    Posts
    1

    Question Create a second sheet that user can filter/search to mirror a protected sheet

    I've created a shared Google sheet that has various columns with different sets of data in them. This sheet is locked so it cannot be edited by viewers. What I'd like to do is create a 2nd sheet that references the data in the first sheet and provides a way for viewers to filter/search specific criteria that will return the full results. An example of this would be -

    Sheet 1
    Columns: Employee Name, Office, Address, Phone Number, Title

    Sheet 2
    Viewer can filter/search by any of the criteria on sheet 1 and all matching results are displayed

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. I have updated it for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 06-02-2023 at 10:49 PM. Reason: Change title from "Google Sheets Inquiry"
    Reply With QuoteRegister To Reply
  2. 06-03-2023, 11:16 AM #2
    janmorris
    janmorris is offline
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Create a second sheet that user can filter/search to mirror a protected sheet

    "Viewer can filter/search by any of the criteria on sheet 1 and all matching results are displayed"
    IMPOSSIBLE !!!

    Viewers can NOT edit and therefore can not make changes to the file so can not do any filtering.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google SHeets: Count Checked checkboxes in filtered data of google sheet
    By Faizan Naseem in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 07-07-2022, 05:42 AM
  2. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  3. (Google App Scripts) Copy and paste value for all Google Sheets contained in one folder
    By bobbiekan in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 09-29-2021, 11:48 PM
  4. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  5. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  6. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  7. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1