Sheet Navigation on behalf of condition

[Shahzad_Ahsan]

Hi

I am using "Button for Navigation" from Dashboard bundle.  (See attachment)

I want to navigate between sheets on behalf of condition

Eg: "User1" should navigate to "Sheet1" and "User2" should navigate to "Sheet2"  from the same button.

Is this possible or not?

[Anismohamed32 · Accepted solution]

Hi !! 

I hope its easy if you use the osuser() to find the user logged in.

Syntax :

if(osuser()='DomainName/UserName1','Sheetid1',

if(osuser()='DomainName/UserName2','Sheetid2'))

Example :

If(osuser()='Domain/antony','dc127a0c-e4d4-471b-977e-85d9a184af01',

if(Osuser()='Domain/Matt','re427a0c-e4d4-471b-977e-85sfdgd4af01'))

Try it ... Hope it works ...

[Shahzad_Ahsan]

Hi Anis

Thank you for your suggestion. 

I already tried this but i was giving wrong sheet it.

Now its working fine.