Multiple sheets visible as per the seelction?

[#1]

Hi All,

I have a field(Property), as per the values i am creating number of sheets with same names.

Now i have done something like as per the no.of values seelction from the field,i am showing the corresponding sheets.But some problem is there.

For your reference,I am attaching a sample application.Please go through it and send your responses to make it correct.

Thanks in advance.

Regards

Kumar

[#2 · Accepted solution]

Use the following conditional expression:

=SubStringCount(Concat('#' & Property & '#', '|'), '#Lux#')

Attached you also have the modified document.

JG

[#3]

Hi JG,

It is good but the default sheet should be "Main" when nothing was selected from "Property".

I have modified the condition like  

=SubStringCount(Concat('#' & if(GetSelectedCount(Property)>0,Property & '#', '|')), '#Lux#')

Thanks a lot for the solution.

Juan Gerardo Cabeza wrote:

Use the following conditional expression:

=SubStringCount(Concat('#' & Property & '#', '|'), '#Lux#')

Attached you also have the modified document.

JG

Regards

Kumar

[#4]

i have changed the way variable storing the values,

Hope the attached solution will work and help you.

Thanks & Regards,

Venakt T