Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a sheet that I want to hide to specific users bases on OSuser().
I used this in the conditional show:
=if(match(osuser(),
'GLOBAL\A',
'GLOBAL\B',
'GLOBAL\C',
'GLOBAL\D',
'GLOBAL\E')=0,0)
Meaning that if the user doesn't match A, B, C, D, or E, the sheet will be hidden. However, user C cannot see the sheet, whereas user D can. Why would this happen? Thanks.
Check the ID that is displayed in the AccessPoint page (top right corner) for user D. Does it match GLOBAL\D?
Also two suggestions:
=if(match(osuser(),
'GLOBAL\A',
'GLOBAL\B',
'GLOBAL\C',
'GLOBAL\D',
'GLOBAL\E')=0, 0, 1)
I presume you have given sample users above.
For your real if() with the real users I would double check for any typo's.
I've checked for typos - the expression works locally between my server account and normal account. e.g. if I my server account is D, and I open the doc on my server account, I can view the sheet. The same if opened on my normal account, hides the sheet. So I'm expecting it to work on the server but it's not.
Check the ID that is displayed in the AccessPoint page (top right corner) for user D. Does it match GLOBAL\D?
Also two suggestions:
=if(match(osuser(),
'GLOBAL\A',
'GLOBAL\B',
'GLOBAL\C',
'GLOBAL\D',
'GLOBAL\E')=0, 0, 1)
Checked the right corner, it seems capitalization matters. I was doing GLOBAL\user_a when the user was appearing as GLOBAL\User_A