I want to have the app open on a different sheet for different user groups. I know I can set which sheet it opens with by using a bookmark but this is the same for all users.
You can create the sheet group :
here I have create inline table in section access for Different department and assign the department to different user and then create the sheet group as.
Table_name:Load * Inline [DEPT,GroupSheetIT,100100FINANCE,010010ALL,111111SALES,001001 ];
after that you need to set sheet condition as mid(GroupSheet,1,1) assign it to user you want.
here mid(GroupSheet,1,1) second parameter is your sheet number
View solution in original post
you can have a look on below link that might helps you.