Dynamic view Filter not showing Shared Filters

My sheet has several shared filters.

How do I get these to appear in the Filters for the Dynamic view?

I can't create the filter in the Dynamic View as there is no filter option for Current User, so I need it to use the Shared Filter from the Sheet. I can't restrict the dynamic view to the current user as I need the to be able to see all the data but with the option of filtering it on themselves

Answers

  • Scott Orsey
    Scott Orsey ✭✭✭✭✭

    Sorry... I share your frustration and have wanted to do this myself. You need to create the shared filters in the dynamic view and you can't access the sheet filters.

    The best I have come up with is to 1) include the contact column in the display and then 2) create a "template" filter based on the contact column and tell my users to copy it and sort for their own name. That's a one time setup and the filter will remain available to them whenever they open the dynamic view.

    Not ideal, so maybe submit as an idea.

    Hope this helps

    Be well

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!