Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Current selections for each sheet

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.

2 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
devarasu07
Master II
Master II

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