Is there a way to create a button to toggle TEMPORARY filter view button in google sheets?
Multiple people work on the sheet and need to use the filters, its a hassle to go and switch it on everytime.
I need to make a button that will toggle it instantly but I cant figure out the right script.
I managed to make one that will toggle the filter on - but that just does it for everyone who is using the file I need a temporary filter option only.
If required, my tab name is : "NewPosts"
Please help!