Section access

[Ame]

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?

[tresesco]

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.

[Ame]

@tresesco , Thank you for your reply, can you give me an example of how to restrict data for specific sheets?

Regards,