thank you bro you saved me from giving full access to my Gmail account to my crew
@janicevalerielaguardia1401
2 жыл бұрын
just what i needed, thank you!
@alimezey5217
Жыл бұрын
This is exactly the information I was looking for - thank you!
@mablehope6109
3 жыл бұрын
Thank you s much! Ive finally found someone that is clear and concise.
@JimTheProducer
2 жыл бұрын
Thank you. After a little while of searching I found what I needed. Great video!
@vladislav_salontaj
2 жыл бұрын
Thank you
@lisameager7784
3 жыл бұрын
Thank you. This really helped me.
@GMinihisht
7 ай бұрын
thank you, very helpful video
@ProlificOaktree
6 ай бұрын
Glad it was helpful!
@niranjandas1987
2 жыл бұрын
Nice
@abdulhaye5101
3 ай бұрын
Hello sir I am using google sheet and I have two people attached to it, well I want if I do any work on google sheet then the notification will go to them in the same way if they do any work I have the notification that it is possible
@chrisholsinger6377
2 жыл бұрын
Thank you, informative and easy to understand
@emmat5119
3 жыл бұрын
That was brilliant, thank you so much ☺️👌🏼
@ProlificOaktree
3 жыл бұрын
Glad you enjoyed it!
@NomadicVanman
2 жыл бұрын
How can I share or give my sheet creation to someone as a stand alone sheet. Meaning they get it as a blank sheet that is a data entry sheet and another sheet to hold the data. No data should be in the database. Now they can take these sheets and enter their own data and use how they like. They should be able to edit it as well. Thank you for your help.
@ProlificOaktree
2 жыл бұрын
You need to break it into two files.
@milosjankovic4329
2 жыл бұрын
Thanks mate,it helps!
@ericabarnabas607
2 жыл бұрын
Thank you very much
@sadikshaikh6876
3 жыл бұрын
how to give spiciffc column access to the other users to edit the excel
@omarmzory
3 жыл бұрын
Hi Can you share it with many offline users, then if they changed anything and when they become online the data will merge or not?
@ProlificOaktree
3 жыл бұрын
That's an excellent question and I have no idea. I'm going to add it to the list of things to look into for an upcoming video.
@J_D_J
Жыл бұрын
Excellent video. Thank you. Also, can I ask if you have a tutorial on how to send one Google sheet to multiple people, and each person has their own independent version that they can edit without it editing or effect another's copy? i.e: 1 sheet, 4 users, none editing each others sheet. I hope that makes sense :- )
@ProlificOaktree
Жыл бұрын
Hey there. Take the sharing link and change the last part to /copy. Look at how I did it here sheetshelp.com/query/
@dammythecreator
Жыл бұрын
@@ProlificOaktree Mine ends with edit, so do I erase edit and replace it “copy”?
@shadhinhosen6951
2 жыл бұрын
Just osm
@vijaykumarcg44
2 жыл бұрын
Very nice information, how many people can logon to the spread sheet to edit the spread sheet @ one time, 10,50, or 100 please suggest.
@ProlificOaktree
2 жыл бұрын
I think once you get into the hundreds, it can slow down a bit. Not sure of the exact number.
@jibbosuppipat7482
2 жыл бұрын
if i do the google sheet for the employee assessment. how can i share with all the employee to do the assessment and gather the result?
@mushahidhussain56
3 жыл бұрын
Thank You for the much valueable information ❣
@ProlificOaktree
3 жыл бұрын
Glad it was helpful!
@erickabumotad654
2 жыл бұрын
i can't share a spreadsheet with others. it keeps on saying that my sharing quota has exceeded. but the storage isn't full yet. how can i fix this? thank you for the answer.
@xasber3127
3 жыл бұрын
Btw can I see a some kind of history for who added who/ who removed who..?
@ProlificOaktree
3 жыл бұрын
Not that I'm aware of.
@vinaysimha95
2 жыл бұрын
Is it possible to share with anyone, but make them login with a google account? Instead of them accessing the sheet with no login?
@PakCoyMan
2 жыл бұрын
I have a problem I share my spreadseet to 2 users When i change something in that spreadsheet, user 1 just normally see the change, but user 2 cant, user 2 is stuck with data that i shared at time so if something changes user 2 cant see it How to fix this?
@koaboyy
3 жыл бұрын
if wanting to send google sheet to a client is it better to share or email them the sheet?
@LivDeeper10x
2 жыл бұрын
Very helpful video, thanks! Is there a way to have a link that you can send to lots of people - but it makes each their own copy - each person can edit their own copy BUT those edits don't change the original file? Thanks very much in advance.
@ProlificOaktree
2 жыл бұрын
Yeah, just change the ending to /copy. Look how I made the link to the template on this page sheetshelp.com/query/ where it says go to this spreadsheet.
@earningfundaofficial
11 ай бұрын
Temporary access nit working now a days
@sebastiaocaetano3116
2 жыл бұрын
Estou gostando da idéia é boa.
@ProlificOaktree
2 жыл бұрын
Uhhh
@omorkhan3437
3 жыл бұрын
thank you
@JohnEboyee
2 жыл бұрын
You didn't cover it but my director asked for access to share my sheet. He was assigned editor and had all access like the rest of my team.. 8 hours later I realized that he had no reason to share the sheet. This is shared amongst the team. Weirdo.
@RudiEdukasi
4 жыл бұрын
Terima kasih atas videonya sangat bermanfaat..
@ParthuXYZ
3 жыл бұрын
I publish my google sheet, but in pdf format it's always show in lendscape but I want to change in to portrait how do i do?
@user-jo8uh5sl2s
2 ай бұрын
*Is it possible to share only one tab of a google sheet with editing permission and not share the whole sheet?) (while staying in the same sheet)*
@ProlificOaktree
Ай бұрын
No, you'd have to try something like this: kzitem.info/news/bejne/tq94uYydrWSQjJw
@nedh.8792
Жыл бұрын
Very good content. So I'm thinking of creating an online newsletter where subscribers (and only subscribers) would have access to some google sheets. Will I need a G Suite account (or Google Workspace) to limit access to newsletter members? And will I use the "Get Link" option for this approach as opposed to share with groups? Thanks.
@ProlificOaktree
Жыл бұрын
I talk to another Google Sheet video maker about sharing / paywalling here if you want some discussion on the topic. Shortly after this timecode I think: kzitem.info/news/bejne/poOEnKJ-jZ2efXY
@nedh.8792
Жыл бұрын
@@ProlificOaktree Thanks! I assume you're referring the Only Sheets app that came up in that conversation? If so I'll check it out. What gave me the idea is this other investment newsletter website I subscribe to, where one time I couldn't access the google sheets link that I had saved elsewhere for quick access. It was then I realized that I once I logged into that newsletter website I could then gain access to that google sheet, even though I was clicking a link that was stored on my google drive. Somehow that google sheet knows whether or not I'm logged in to the host's website. This got me thinking I might want that same functionality for my own online newsletter so as to prevent unauthorized sharing of the google sheets I create. Unless you can think of some better way to accomplish the same objective. Thanks.
@Lyonsgirlsnightin
2 жыл бұрын
What about sharing with the anonymous icons when you don't want them to all have each other's email?
@abdullahquhtani4247
4 жыл бұрын
Great. Is there a way to get a report of users’ modifications (or history) in a separated sheet?
@ProlificOaktree
4 жыл бұрын
Not that I'm aware of.
@austinl9771
2 жыл бұрын
What is the maximum amount of people who can view a sheet at once? I would be the only editor but need to share with over 200 people.
@nitinalistair4285
4 жыл бұрын
Thank you for the video sir 👍🙂
@ProlificOaktree
4 жыл бұрын
Welcome 👍
@mohammadmostafa7936
3 жыл бұрын
Sir can u tell me how to check users Daily performance in google sheet
@tanialol101
3 жыл бұрын
I have a question. Once you share it with someone, if you change anything in the document will it change on their end too?
@ProlificOaktree
3 жыл бұрын
Yes, everyone is looking at the live document.
@jsgglr
4 жыл бұрын
BTW, thank for the great videos!
@ProlificOaktree
4 жыл бұрын
Glad you like them!
@user-cg5lb6zg5p
Жыл бұрын
Can you share just ONE tab of a sheet with someone without them having access to the whole document?
@ProlificOaktree
Жыл бұрын
Nope!
@tamilarasi971
3 жыл бұрын
Gd evening Sir, Shall we hide one sheet from concern users?????
@empoweringsingh1973
3 жыл бұрын
Hello Sir I have to share Google sheet with 1000 persons , but in certain order so that they can't edit or change data of other cells and one person at time as editor & rest other as viewer ....Is it possible ?? Thanks
@ProlificOaktree
3 жыл бұрын
Not that I know of.
@MrEasyFlying
3 жыл бұрын
Great tutorial. Thanks. I have a Google Sheet with Script. I can share but the script doesn't run for others. I tried the Deploy from the script and it still didn't work. Do you have tutorial on sharing sheet with script?
@ProlificOaktree
3 жыл бұрын
No, I am not sure on that one. I share some with scripts and it seems to work most of the time but I do have some people tell me it wouldn't run.
@omprakashgunarat
2 жыл бұрын
3:09 im not able to see both names on my sheet (owner sheet). But both names can be seen on the sheet opened by shared person, but not on owner sheet. Why is that so, can you help me out. Please..
@ProlificOaktree
2 жыл бұрын
I don't know. The only guess that I have is that your internet connection was interrupted so you were working in offline mode.
@omprakashgunarat
2 жыл бұрын
@@ProlificOaktree no, im working online, i followed the same steps, as in the video. Anyways thnk you so much for presenting this explanation.
@nivigupta9605
3 жыл бұрын
I gave access to the other person but that person is not able to see the screenshots which are uploaded in my drive, it asks for Permission for each screenshot he opens. please guide.
@ProlificOaktree
3 жыл бұрын
If each screenshot is a separate file, you need to share each one or the folder that they're all in.
@mariaignatiusrithesh.2249
4 жыл бұрын
Thanks sir
@thearidjakalsshow
2 жыл бұрын
Hi there, I want the person I’m sharing the google sheets with to edit and have full control but I don’t want to see their edits because it’s private to them… is this possible and how please ?
@ProlificOaktree
2 жыл бұрын
Hey there, thanks for the question. I can't think of a way to share a spreadsheet but not see the edits. I think you'd have to use two separate spreadsheets for that.
@thearidjakalsshow
2 жыл бұрын
@@ProlificOaktree thank you
@farshadbolouri9035
2 жыл бұрын
hey man how can I sell a Spreadsheet and ensure no one cant copy it but is able to have a copy for himself and cant see formulas? is there any way ?
@ProlificOaktree
2 жыл бұрын
You can change the end of the URL to /copy and they would get their own copy. The formulas would still be there though.
@reg5564
3 жыл бұрын
Hi, I'd like to ask what if I'm not the owner of the sheet just an editor, can I still add other people on that sheet without notifying the owner of the sheet?
@ProlificOaktree
3 жыл бұрын
You should be able to.
@janielletulloch4761
4 ай бұрын
How do you fix a link that won't open? I copied the link and change the ending of the link to say copy so they can automatically copy the link but it won't open.
@ProlificOaktree
4 ай бұрын
I'd have to see the link.
@janielletulloch4761
4 ай бұрын
@@ProlificOaktree It's working now but thanks for responding.
@Freddytacvbito
2 жыл бұрын
do people have to log in in order to see the spread sheet?
@ProlificOaktree
2 жыл бұрын
Yeah, I think so.
@jsgglr
4 жыл бұрын
One thing I have not been able to figure out is what is the difference between "Get shareable link" (With option to turn shareable link off) versus simply copying the URL for the document. I kinda think I read something about getting shareable link, will create document specific share attributes (versus inherited) if using the shareable link??? Is that right? Do you happen to have info on this?
@ProlificOaktree
4 жыл бұрын
I don't really know so I always get the link the way I show in the video so that I know it will work as intended.
@jsgglr
4 жыл бұрын
@@ProlificOaktree thanks. It's what I do too., It's just that the get shareable link option is so prominent
@karinm-yan3219
3 жыл бұрын
the link of the spreadsheet is very long, is there a way of shortening it so that people won't get such a long link ?
@ProlificOaktree
3 жыл бұрын
Easiest way is probably to use something like bit.ly. That's what I use to shorten links.
@sockneman
11 күн бұрын
Can people download an own copy of your shared "restricted" Google spreadsheet?
@ProlificOaktree
7 күн бұрын
Yes, go to File, then choose Make a copy. Don't download it.
@sockneman
7 күн бұрын
@@ProlificOaktree Great! Thanks! 👍
@LotfyKozman
4 жыл бұрын
Can I share just one sheet amongst several sheets in the same workbook so the receiver can't see the other ones.
@ProlificOaktree
4 жыл бұрын
No. They can always see them. You can use the "Protect" functionality, but that's permissions and not what you can see.
@Mabeylater293
3 жыл бұрын
@@ProlificOaktree that’s terrible. There’s got to be away where you can allow each customer to see their own spreadsheet without them seeing other customers info. That’s such a basic request I don’t see how google would omit this. There has to be a way surely, right?
@vrtsdemise
4 жыл бұрын
How can you make your sheets a public sheet for everyone to see on mobile phone
@ProlificOaktree
4 жыл бұрын
From the first screen where you see all of the files, click on the three vertical dots and pick Share.
@krishansharma983
3 жыл бұрын
Is there any way to share filtered data based on value of any cell.
@ProlificOaktree
3 жыл бұрын
Maybe a new sheet and a combination of IMPORTRANGE and the FILTER function.
@regularguy2200
2 жыл бұрын
I have a spreadsheet with formulas that I want to share anonymously on a forum. Its a cooking calculator. Ideally people could open the sheet and enter their own values, but they won't be able to make changes on the original. Any way to do that?
@ProlificOaktree
2 жыл бұрын
Make the link have /copy on the end so that they are forced to make their own copy. Look at the template links here for an example at the bottom where it has a link to spreadsheet. sheetshelp.com/arrayformula/
@regularguy2200
2 жыл бұрын
@@ProlificOaktree This is helpful, but I found an issue. If they just delete "/copy" from the end of the link, it reverts back to being view/comment/edit and still displays my info. When I tried the same for the link at the bottom of that article, it does not display the owner of the sheet. but it does open it in "view only" mode.
@ProlificOaktree
2 жыл бұрын
@@regularguy2200 Try it from a different Google account. Sounds like your opening it again from your account.
@navsram
3 жыл бұрын
hi , can I know that sheet can I share on Whatsapp?
@ericjohnson-qr8dt
3 жыл бұрын
Can you share this to only read or download?
@ProlificOaktree
3 жыл бұрын
Yes.
@stingerhd12
4 жыл бұрын
How to remove sharing with multiple email ids at once?
@ProlificOaktree
4 жыл бұрын
Can't you just go back into the Sharing menu and X them from there?
@engelengelis1964
2 жыл бұрын
how can i share people one at a time?
@ProlificOaktree
2 жыл бұрын
By entering their email addresses.
@garyfiedler7283
3 жыл бұрын
Thank you for taking the time to make this informative video. :)
Пікірлер: 117