Conditional function

tizianacaem · ‎2010-09-16

Hello everyone.
I have a problem with the conditional functions of sheets.

I have the following list in a xlsx file

User, Sheet

user1 SH01

user2 SH02

I want to show only certain sheet (es SH01 but not SH02) for a user (es user1).

In each sheet I used the expression: fieldindex ('SHEET', SH01) but it does not work.

Suggestions?

Thanks Tiziana

Report Inappropriate Content · ‎2010-09-16

<body>Hi, To do this you need to create an excel sheet like follows (assign '1' for the sheets the user wants to see and '0' for the sheets user doesn't want to see and then in sheet properties use conditional show =sum(distinct (SHEET1)=1) <col span="3" width="64"></col> <tr> <td width="64" height="20">USERID</td> <td width="64">SHEET1</td> <td width="64">SHEET2</td> </tr> <tr> <td height="20">USER1</td> <td align="right">1</td> <td align="right">0</td> </tr> <tr> <td height="20"> USER2 </td> <td align="right"> 0</td> <td align="right">1</td> </tr> </body>

Report Inappropriate Content · ‎2010-09-16

The table should be like this.. and make sure to select 'Initial Data Reduction based on Section Access' "(Document Properties> Opening)

Regards,

Nilupa

Related Topics