Did you know you can chat with your team within Google Sheets? This is one of my favorite features. I can talk to my team in real time about the data in my spreadsheet. For example, if I have a question about something I can come up here at the top right, select chat. Keep in mind that this feature won't be available if you're the only one in the spreadsheet. Enter your message in the chat box. Once I'm in the chat box, the user I'm addressing will receive an email notification that I'm addressing them. If they're not in the sheet already they can reply via email or the alert will prompt them to head back into the sheet to answer my question. When you're finished at the top right of the chat window select close, cool. So just got some questions answered and that is how you chat with a teammate. On the theme of making your spreadsheet social, let's talk about how to add notes. You can add a note or annotation to explain trends in the data or to give your team additional information or details about your data or charts. All right, choose which cell you want to tie your note to. Now, let's go up here to insert. Select note and now we can write a note here. There we go. We've shown you notes. Now, let's go over how to mention someone in a sheet with comments and action items. Adding comments in Google Sheets is a really useful way to add information, suggestions, or questions for other collaborators to read in the spreadsheet. Sometimes you have questions about a data point or trend. The best way to get immediate feedback from a teammate is to tag them in the spreadsheet. To make sure someone sees a comment, you can add them to it. They will receive an email notification with your comment. Let's go ahead and mention Mabel and a comment on our spreadsheet. So let's select the location or the cell that you want to comment on. And then click up here, insert and somewhere in your comment add the name of the person that you want to tag. When the correct person is suggested, click their name. You can also add the email address of the person you want to tag. Click comment to share. Depending on your personal settings, you'll get a notification message when someone tags you in a comment. You can manage your comment notifications up in comments and set to only alert all comments, only yours, or none. If you have permission to edit or comment on a spreadsheet, you can reply to comments. When a discussion is finished, you can resolve a comment to close it. To reply back to a comment, you just need to click on the comment itself and go ahead and type in your reply. Another thing we can do here in comment is review history. And here we see Mabel's comment again. Well, actually see all past comments made on the spreadsheet, the time and date of those comments. All right, time to cover how to create Google Forms. One of the best ways to collect data is by asking people. Google Form is a great tool that integrates directly with Google Sheets so that you're able to ask questions get data in a structured format. And it immediately comes into a spreadsheet so you can start analyzing and understanding the data. We have a lot of information on cold hard facts in our spreadsheet like revenue and actors' names. We know how many movies were action movies or romances, but maybe we want to get insight into what genre is people say they enjoy the most. So we measure sentiment or how people feel about different movie genres. We can create a Google Form that will collect data on people's favorite movie genres and our company will distribute it via our social media channels to get a sense of what our community wants. Let's do it. Go to your Drive by typing drive.google.com in the URL. Select new, more, and then Google Form. First off, let's give our Google Form a title. We'll call this genre sentiment data. So these are optional but we can add a description. For question one, let's ask their email. For question two, let's talk about genre sentiments. And you can keep adding questions here. Then you can check the responses section for a visual summary of our collected data. The last collaborative feature I want to show you is when you send a form you can gather responses inside the form or separately in Google Sheets. Open a form in Google Forms, at the top of the form click responses. And here click create spreadsheet, this creates a spreadsheet for responses. Select existing spreadsheet, this lets you choose from your existing spreadsheets to store the responses to this Google Form. So for this we're going to save the Google Form responses in our spreadsheet here. Click select in this case, cool.
