Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@tresesco , Thank you for your reply, can you give me an example of how to restrict data for specific sheets?
Regards,