Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am currently developing a dashboard which contain several sheets. each sheet has its own subject, they are independent from one to another.
I would like to have a current selection box for each sheet without the selections of other sheets appear on the box.
Is it possible? i tried set up one alternate state per sheet, but it does not seem work.
Thanks in advance.
This should work, When you apply "Alternate States" for "Filters" also. That means, You need to take Alternate to List box as well until unless it won't effect in your Current Selection
Hi,
another way by using the Sheet event Trigger with action method. for more details check this article
Re: Independent selections in different sheets
Thanks,
Deva