Show/hide sheet for few users

[sridhar_sigired]

Hi,

I have one sheet where i need to show only few users. Can we do this without using section access? If yes, how we can achieve this?

If No, can have process how can we do this? Please help me. Thanks.

Regards,

Sridhar

[adamdavi3s]

Use this formula on the sheets to account for NULLS

=if(len(only({<userid={$(=OSUser())}>}show1))<1,0,only({<userid={$(=OSUser())}>}show1))

As Richard has said, if it is only a few users then hard-coding them and using a match will be quickest, my solution will allow you to update easilly and also pull from a SQL table / spreadsheet if you wanted.

Its more complex but IMHO more future-proof

[sridhar_sigired]

Yes, i have only 3 fixed users who need to see this sheets. I have tried the below formula for sheet condition.

The first user is mine, i can able to see the sheet even if i keep this or remove this. In the both cases, i can able to see sheet.

=if(match(Upper(OSUser()),'CTC\SRIDHAR_S',  'CTC\RAJESH_Y',  'CTC\BHOPESH_Y')>0, True())

=if(match(Upper(OSUser()), 'CTC\RAJESH_Y',  'CTC\BHOPESH_Y')>0, True())

[adamdavi3s · Accepted solution]

Try adding the negative result to the IF as well

=if(match(Upper(OSUser()),'CTC\SRIDHAR_S',  'CTC\RAJESH_Y',  'CTC\BHOPESH_Y')>0,1,0)

=if(match(Upper(OSUser()), 'CTC\RAJESH_Y',  'CTC\BHOPESH_Y')>0,1,0)