I have a Field on a particular sheet (this sheet has its own group of actions - lets call it Sheet1),
On this Field I've placed a Field Event Trigger to activate another sheet.
On the sheet that is activated i have an OnActivateSheet Trigger which has its own group of Actions (let call this Sheet2).
But it seems like the Actions set out in Sheet1 are carried over to Sheet2 when activated and ignores the actions on Sheet2.
Is there anyway for the actions/selections in Sheet1 to be cleared when Sheet2 is activated?
Ive tried ClearAll and ClearField on Sheet2 as well as ClearAll OnLeaveSheet for Sheet1 - but it doesnt seem to solve my problem.
Any help would be appreciated.
Can you give me an example please - im tying it but it doesnt work entirely.
If i place it in an alternate state it clears everything.
How do i create a state inclusive of sheet actions.