Sheet Sharing / Default View
Quick question on setting a Default View when sharing a sheet. I have a sheet that contains employee information that requires quarterly updates. Currently we are NOT sharing the sheet due to sensitive information contained in the sheet. This means a report for each supervisor to edit their employees will not work because the underlying data is not shared. We want the supervisors to only see those employees they supervise.
My question is if I create a default view for each supervisor and share the sheet using the Default View selecting their specific named filter, set it to Grid View are they able to turn the filter OFF once they access the sheet?