Hi. I am using section access to limit the access level of the data for each department, each department chief should only see the data of their department, but for some sheets, I want them to see all the data. Is there a way to do that?
For this, you need to allow the users/user group access to all data, and then for restriction in UI (specific sheets), use expression like : if (OsUser()= 'XXX', ....) . Other ways could also be there based on your access complexity - using inline table for flagging associated data.