Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have two buttons on my sheet.
Is it possible to set a clear state once a button is pressed and remove the clear state once the other button is pressed?
Any help is greatly appreciated.
Thank you
Parth
Yes. it is possible.
1. First button trigger should be set to Selection -> Clear All
2. Second button trigger should be set to Selection -> Back
Hope this helps.
Hi Krishnapriya,
Thank you for your response.
I have already applied a bookmark once the first button is pressed. Even though some one presses the clear all I dont want the bookmark to be removed.
Once second button is being pressed than bookmark should be removed. Even after someone presses clear all button it should work normal.
Please let me know if this is achievable or not.
Thank you
Parth
Hi
In bookmark try to lock the selection. so that if clear all is selected also bookmark selection will be removed.
in second button you unlock the selection and add then add clear action, to behave as normal.
Hope this helps