Is there a way you can "lock" a specific filter on by default for a sheet you publish to a dashboard?
I'd like to have the sheet editable from the dashboard, but I'd like it filtered to "current user" so it can act like a one-stop shop for everyone to review the reports and update the sheet at once. I have one filter on each sheet, but when I refresh the page, they default to the filters turned off. And I can't get an editable version of a report to work on the dashboard.
Does anyone know if it's possible to have a specific filter on by default when a sheet is published like this?