Hi Everyone! I encountered this problem at my work place.
QN: I have 1 dashboard and 3 worksheets in my Workbook. There are different types of users (Vice president, Market manager, Regional manager, Store Manager). I already secured/limited the access of data as per their designations. Now the challenge is I have to give the Actions for the navigation of sheets for different users in the following way..
'For Vice President, the navigation should follow like DASHBOARD 1 --> SHEET 2 --> SHEET 3 --> SHEET 4.
For Market Manager, the navigation should follow like DASHBOARD 1 --> SHEET 3 --> SHEET 4.
For Regional Manager, the navigation should follow like DASHBOARD 1 --> SHEET 4.
For Store Manager, Its just SHEET 4. or we can give it like DASHBOARD 1 --> SHEET 4.
Please somebody get back to this.. Thank you
Is it possible to have 2 additional dashboards for the first two users? The flow is the same with the addition of the intermediate steps so a different starting dashboard sounds like it should work.