Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I want to enable my current selection box when any selection made in sheet, rest of time it should hide. What is the way to do that help on it .
Thanks & Regards
Pavan
Hi Pavan
Replace the variable definition with this logic
"=if(count(GetCurrentSelections())>0,1,0)" and go to current selection box properties --> layout ---> show---> conditional
and write vShow=1.
I'm sure it'll work.
Create a variable vShow. Like
LET vShow = IF(Getcurrentselections() >0, 1,0);
Then in any sheet object properties -> Go to Layout Tab -> check conditional and type =vShow
I hope this would work.
Hi vishwanath,
Thank u, but my requirement is initially current selection box should be hide, when made selections it would be active show.
Hi Pavan
Replace the variable definition with this logic
"=if(count(GetCurrentSelections())>0,1,0)" and go to current selection box properties --> layout ---> show---> conditional
and write vShow=1.
I'm sure it'll work.
Hi sudhir its perfectly working. Thanx on ur work.