Row/Column Level Access
I have sheet on which people from multiple departments will have access to. A couple of my requirements:
1) I'd like certain departments to be able to see only the data in specific columns only relevant to them. Is this possible?
2) There are 3-4 attachments that will be added to the rows. I do not want departments having access to attachments which are not relevant to them - I understand that it is not possible to regulate this access but any suggestions on how to work around this? I'd create a Report for each department's data but the attachment for that row would not be visible in the Report