Okay. Let's go over how to maintain control of your data. With Google Sheets, you can manage permissions for your document. You can set expiration dates for those permissions and you can even disable options to download, copy or print for specific collaborators. Let me show you a few ways to manage and maintain oversight of your data. You can also change the ownership of a spreadsheet. Maybe we worked on this spreadsheet but Maple is actually going to be the one to eventually present this. So we can actually transfer ownership when we're done preparing it on Maple's behalf. So let's open share, we'll go to Advanced, and then here you would find the person you want to transfer ownership to and in our case we want to share this with Maple. So click here and select is owner. So now Maple is the owner of this spreadsheet. Now that we've shared our spreadsheet with the team, let's learn how to review our sharing settings. So in our spreadsheet, let's go ahead and select Share, and we can access different sharing document links here and we can also see who has access to the spreadsheet and if they can edit, can comment, or can just view. Here you can also see that we have the option to set an expiration to access the spreadsheet. You can make whatever changes you'd like, just confirm your edits and save changes. Since we started research and preparation of the film we were making, our crews grown a bit. We've enlisted the help of a couple of coordinators to sift through the data. Now some more of the producers want take a look at things as well. So now since more people are working on the spreadsheet and viewing it, we want to be able to see who chimed in and when. So let's check it out. Here, this is where we can review access permissions for everyone who you have shared the spreadsheet with. Sheet allows us to view the history of collaborators. It's nice to be able to have visibility into who is using a spreadsheet and when regardless of what you're working on. Now, let's go over how to lock data ranges and sheets. You can protect your spreadsheet from being changed by others. But keep in mind they'll still be able to do things like print, copy, paste, import/export, and screenshot a protected spreadsheet. But if I'd like to share the spreadsheet with a collaborator but don't want them to be able to edit values, we can lock data ranges and sheets appropriately. All right. Go to data. Click on ''Protected sheets and ranges'' here. We'll click ''Add a sheet or range''. To enter the range you're protecting click here and highlight the range in the spreadsheet. Let's say we don't want our team to modify the budget or box office revenue data because that's going to change all of our tables and data summaries. Just click Set Permissions''. Here, choose how you want to limit editing. This one's useful. We can show a warning when anyone makes an edit on our sheet. Select ''Show a warning when editing this range''. This one doesn't block people from editing, but they'll see a message pop up asking them to confirm if they really want to make an edit. We can also choose to protect an entire sheet in our spreadsheet if we wanted to. Let's lock down our middle data sheet. All right. Open data. Again, go to protected sheets and ranges, and now we choose a sheet to protect. If you want a set of cells to be unprotected in a sheet, check the box next to except certain cells. Hit ''Set permissions''. So in this example, we don't want anyone being able to modify our report sheet. We'll choose the second option. Restrict who can edit this range. Here we have a few different options. If you use Google Sheets for work or school, only people in your email domain can edit the range or sheet. Here on custom, only the people you choose can edit the range or sheet. So for our example, we want to limit this to only we can modify these settings. So that's how to restrict people from editing or entering data in general. So now let's cover how you can restrict people from entering invalid data. Data validation can be used to stop collaborators from inserting anything other than the data you want within specific ranges. We have various options here. We can set text only, dates, set a specific range and more. Let's go back to our Have you seen this column. Now, we want to add a new data point. We wanted to know when the movie was seen. Let's use the Data Validation to collect this new data point. We also want to restrict people from entering invalid data. So we only want to see date inputs. Let's create a new column and rename it to, When have you seen it. Highlight the range you want to restrict. So let's just do the entire columns range. Go to data, select data validation. Now here in criteria, we specify what type of content we want inputted. We only want dates. Then we need to select what happens if invalid data is inputted. Here we can choose if sheets shows our collaborators a warning message, or simply rejects anything that's invalid to our requests like if a teammate accidentally enters currency instead of a date. If you select reject input, your collaborator will see a pop-up window with an error message after they submit the invalid data. We can also include Show validation help text so your teammate receives a helpful message so they know how to fix the error.
