I am currently helping a company with their booking system. It uses Google Sheets.
I know that data can be shared between sheets. I am wondering if data can be shared between sheets, such that
- sheet A references sheet B.
- sheet A is readable by user, sheet B is not readable by user.
I realise that with conventional file security this is impossible. However because Google Sheets is hosted, it could be done. (like Unix set UID/GID (on executable files): Sheet A and B are owned by user U, who has all permissions, user V has read on sheet A. User U adds set GID to this copy of sheet A.)
So is it possible using Google Sheets?