make a sheet visible only if more than 3 filters are selected

[#1]

Hi

Is it possible to show a sheet only if 3 filters are selected. plz let me know if its possible.

Regards

Sagar Gupta

[CELAMBARASAN]

Hi,

     how many filters you have?

     you need to frame expression like below and which is to be placed in Sheet properties-->General-->conditional expression

     =RangeSum(if(GetSelectedCount(Field1),1),if(GetSelectedCount(Field2),1),if(GetSelectedCount(Field3),1),

          if(GetSelectedCount(Field4),1),if(GetSelectedCount(Field5),1),if(GetSelectedCount(Field6),1))>3

Celambarasan

[johnw]

This might work:

substringcount(getcurrentselections(),':')>=3

[Anonymous]

  substringcount(getcurrentselections(),':')>=3

That's a nice solution John.

Works perfect here.