Hi, maybe instead of filtering it is easier to use few navigation buttons? It is very easy to set in this case, just add button from custom objects panel, choose navigation action 'Go to sheet' and select sheet to which one you want to redirect.
When the project manager logs in he can see his projects in a table with some some key numbers to show how his projects are going. When he clicks on a project I want to show a totaly different view so I want to jump to another sheet showing a number of charts and tables for this specific project.
You could create an object where the project is actually a link and then use that link to open a different sheet. As far as I know, there's no built-in trigger-on-select option like there was in QlikView (which honestly is for the best, users just found it confusing for the most part).
