My first experiment was to try and clear the action filter. So I used code that looks something like:
In this line myDashboard represents a variable that points to the dashboard sheet. This code clears the filter for Sheet1, but Sheet2 stays as it was, generating an incosistent state. Is this a bug, or is it the expected behavior? Is there any way to have the same behavior as a user would have when setting the filter to (all)?
The second problem I run into was when trying to set the filter to a specific value. Here's my code: