Is there any way to share information on a report without giving employees access to the sheet it's connected to. This main sheet uses forms and may carry confidential information and I don't want them to view the full details of the sheet, just a few important key items on a report.
Is this possible?
This is in regards to a PTO calendar and requests sheet that it's attached to.
I want the employees to view the approved request on a calendar in the reports, I don't want them to even have access to view the PTO requests sheet it is attached to.
Thank you for your suggestions in advance!