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