Members-only tutorial

Watch the video and get the practice sheet with membership.

See membership options

Get Data With Comments

About this Tutorial

A great way to manage your data if you have a small group of people who want to add data, but you want control over that data in the sheet. Give them the ability to comment on your data.

Video Transcript

<div> Hi, welcome. I'm gonna share Learn how to share your Google Sheets effectively for collaboration. Opens in new tab with you just some theories on how to get data Discover methods to gather and manage data in Google Sheets. Opens in new tab . The very first thing that you probably. Think about doing is when you want to have a group Understand how to group data for better organization in your sheets. Opens in new tab of people share Learn how to share your Google Sheets effectively for collaboration. Opens in new tab with you some data Discover methods to gather and manage data in Google Sheets. Opens in new tab and you're gonna do something with it, you probably go up to file and share Learn how to share your Google Sheets effectively for collaboration. Opens in new tab this maybe even as a publish Find out how to publish your Google Sheets to the web. Opens in new tab to the web or you click to share Learn how to share your Google Sheets effectively for collaboration. Opens in new tab .<br><br>And you share your edit access and you say, Hey, go edit it or change it or do anything. But what that does is doesn't really allow you to have like an approval process.

If you wanna get approvals, if you wanna have approval over edits, this is a very bad way to do it. And then the second way you could probably do it is like if somebody's looking at a sheet and says, oh, I need to add something to this, then you might want to create a form that is absolutely fine.<br><br>That's one of the most used use cases and ways to get information into a Google sheet with approvals, right? They, you'll create a form and it'll have another tab here, and you'll absolutely be able to get that data Discover methods to gather and manage data in Google Sheets. Opens in new tab and then put it in.

But you're gonna be doing a lot of copying and pasting, and if you want to allow someone.<br><br>To very easily see the data Discover methods to gather and manage data in Google Sheets. Opens in new tab and then comment Explore the benefits of using comments for data input and feedback. Opens in new tab on it, right? What you can do, comment Explore the benefits of using comments for data input and feedback. Opens in new tab here, what you can do is you can share Learn how to share your Google Sheets effectively for collaboration. Opens in new tab and instead of sharing Learn how to share your Google Sheets effectively for collaboration. Opens in new tab them on as a viewer Learn the limitations of sharing sheets with viewers. Opens in new tab or an editor Understand the permissions and capabilities of editors in Google Sheets. Opens in new tab , cause a viewer Learn the limitations of sharing sheets with viewers. Opens in new tab can only see. And an editor can now has access to edit it, share them as a commenter and share anyone with the link.<br><br>If you have a small organization, then you probably want to like, make sure you know who it is. It's actually getting this information.

But I've seen communities, open communities allow anyone with the link Discover how to share your sheet with anyone who has the link. Opens in new tab if they're they want, you know, a few dozen people that may not, may be anonymous or something for some reason.<br><br>But this commenting is really, really good. Because then you can see exactly the cell you need to edit or add information. Comments Learn how comments can enhance collaboration in your Google Sheets. Opens in new tab are viewable by everyone else too. So it's really, really easy to see like a community come together a, a and, and share Learn how to share your Google Sheets effectively for collaboration. Opens in new tab information. So think about that as a creative use case of comments Learn how comments can enhance collaboration in your Google Sheets. Opens in new tab of getting data Discover methods to gather and manage data in Google Sheets. Opens in new tab into your sheet.<br><br>Hi.</div>