Hello, I have a Google Sheet with 29 Tabs, and trying to get 3 of those tabs as the primary views (which I am able to do). The issue is from say one of these main 3 tab primary views, I have set as a table and it has three rows each row should link/reference another one of the tabs in that same sheet. When importing the Sheet as a new app (without the 3 main tabs primary view) it works fine, other than I can only have 4 or 5 primary views showing across the bottom and don’t want to have to access the menu for the others. I added the other 3 tabs for primary views so I could break down the other tabs in hopes of having them being able to be referenced from one of those primary views. But I am unable to figure out how to reference another tab from the sheet to show/open when a row is clicked in one of the primary views. I have looked a referencing, behaviors, actions and expressions and have not been able to figure it out. So for example I would like 3 primary views and for Primary View 1, there are 3 rows with the numbers 123 one in each row. When the row with the number 1 in it is pressed I would like the tab in the same sheet named “1” to be opened. This tab will have at least one row of data.
Please let me know if I need to be more clear or can provide anymore details.