How do I do...

[samvile18]

...the following:

I want to only show a sheet where the OSUser is in a list of 5 people, I know I need to add some syntax to the conditional show of the sheet....I just can't figure out what that syntax should be.

I'm thinking that maybe a match could work, I just can't get it to!

Can anyone help please?

[tresesco · Accepted solution]

try like:

=Match(OsUser(), 'User1', 'User2', 'User3')

[Gysbert_Wassenaar]

if(Match( OSUser() , 'DomainNameHere\UserNameHere1', 'DomainNameHere\UserNameHere2' , ... etc ) , 1 , 0)

[#4]

Insert in Sheet Properties Show Conditional expression this:

i.e.

OsUser()='Domani\Name1' or osuser()='Domani\Name2' or osuser()='Domani\Name3' or osuser()='Domani\Name4' or osuser()='Domani\Name5'  

[#5]

Hi,

Try somthing like this

=if(wildmatch(Concat(list,'@'),'*'&osuser()&'*'),1,0)

where list is user_list....

[jonathandienst]

Hi

Adduming you have the user list in a variable:

Let vUserList = 'intranet\fredb,intranet\joes,intranet\maryp';

Then you could conditionally show the tab using:

=WildMatch('$(vUserList)', '*' & OSUser() & '*') > 0

HTH

Jonathan