I book reservations for a sports team and need to be able to communicate with other parts of the arena what hospitality areas are booked/available. In the past there have been multiple e-mails, reports and spreadsheets which have made everyone's jobs harder. We used a Google Doc last year for the majority of the departments, which worked well, BUT we can not share customer contact information with their sales department for obvious reasons.
Is there a way to either block certain information from view or to have the mastersheet fill into another spreadsheet which can block certain cells or information?
This is an example of the information from the mastersheet.