Hiding a button based on 'the user'

Mon, 27 Jul 2015 15:11:48 GMT

I need to hide certain buttons based on who is accessing the document. I'm already using a show condition on the sheets...

if(sum({<[User_auth] ={[$(vtmpActiveUser)]}>} TabFinancialOps) > 0,1,0)

...and surmise I would need to do the same on the buttons but am unsure as to where to start or how it should be constructed.

Any help / advice would be appreciated and once again, thanks in advance.

Re: Hiding a button based on 'the user'

marcus_sommer — Mon, 27 Jul 2015 15:47:48 GMT

You could use something like this:

if(match(osuser(), 'user1', 'user2', ...), true(), false())

- Marcus