I tested the following using 2 unique Gmail accounts:
User Alice created a Google Group and invited User Bob to join.
Alice created a Google Doc and wrote text.
Alice shared the Google Doc with the Google Group via the group email address GROUP_NAME@googlegroups.com.
Bob could view everything written so far and can edit the document.
Alice then removed Bob ...
This was an issue with the sharing settings on the sheets.
It looks like a sheet that is set to Specific People in the sharing settings cannot be automatically imported into a second sheet. If you have access to the first sheet, you can set up an IMPORTRANGE, but it will not update.
The sharing permissions on the first sheet need to be set in such a way ...
When you pull up the share menu - click the little drop down an choose "view"
ALso if you want to disable copying and downloading, click on "advanced" on the bottom right and check the 2 boxes at the bottom
I just ran into this same issue...we've never had an issue with importrange working across MANY sheets which are selectively shared, but today it randomly stopped working. I ran upon this article in my research.
Upon further investigation, I found that only one spreadsheet that was failing to export--the importrange functions on that sheet were still ...
I already mentioned this on a recent question When sharing folders on Google Drive do users know who else the folder is shared with
Users that are explictely included on the sharing settings could see
who else has access to the file. To prevent this, create a Google
Group, add the collaborators (editors/viewers) to that group then
share the folder ...
It's not about the way you shared; it's about the locale that you use for each spreadsheet.
Go to File -> Spreadsheet Setting -> and make sure you have same Locale and Time zone for both Google sheets. The one you put your data and calculations, and the one you shared with the others, and you used importrange() on it.
https://support.google.com/a/answer/6008339?hl=en states that a search in Drive for is:unorganized owner:me returns orphaned items that you own. Note that it returns the top-level folder if a folder hierarchy has been orphaned.
From there you can use Move... to add item en masse to your own Drive.
EDIT: Some parts of this answer are now obsolete as Find your files - Drive Help was updated recently. This was noted thanks to the answer by Dean Ransevycz
At this time Google Drive doesn't include a view nor a search operator to find only orphaned files. From :
To find an orphaned item, do one of the following:
Search for the item in the ...
The best way to handle sharing files with large and dynamic groups on Google Drive is by using Google Groups, but it's also possible to do the way you are thinking by using Google Apps Script or the Google Drive API and the Google Sheets API
To use a group from Google Groups to handle sharing files, share the files with the group by adding its email address....
Unless something has changed, Google Groups aliases should always dynamically change permissions based on people's membership in the group.
The problem it sounds like you're having is that these docs aren't showing up in UserC's doc list. This is because UserC must first open the document before it will be added and remain in the doc list.
For a single ...
When sharing, the default setting is to allow anyone who has Edit rights to also Share the document.
When you open the share window, you should see some small text at the bottom that says:
"Editors will be allowed to add people and change the permissions. [Change]"
Click on change, and then change the setting to "Only the owner can change the ...
This is what I have found out.
Add formula =importRange(«url of file B»,«range») to file A. This makes the content of part of one file appear in the other (the one with the formula.
Share file A, read only (Do not give edit/write permissions. If you give edit/write permission then they can gain read access to the other file, my editing or adding an ...
Files that are shared with you on Google Drive first appear in the "Shared with me" section. From there, if you wish, you can organize it into folders in your own drive. When you remove a shared file, be it within the shared with me or in your own drive, it really just removes the shortcut to that file. If you had access before, you will still have access ...
We could share files and folders with Google accounts and Google Groups, there is no way to "share a file with a folder" but you could move files owned by you. If the files are owned by other people from the same Organization they should move them.
If the files are owned by people from a third-party organization, AFAIK it's not possible to transfer the ...
Does #2 override or add to the #1 access rights granted?
The only way is by removing that user from the group or to create a new group with the same members except the user that should not have edit access.
The problem turned out to be caused by having a situation where A and B had both been logged in in the same browser at some point in recent memory. Here's the procedure I finally found to solve this problem:
Use two different browsers for this work, e.g. Opera and Chrome.
In Browser A, log in as B, then log out; now log in as A.
In Browser B, log in as A, ...
Create a group
Add all the organization users to that group
Add the group as a member of the corresponding Team Drive
Add all users to a group
Share files with Team Drives
Manage your Team Drive users and activity
For security reasons Google will always show the people a sheet is shared with.
Your only other alternative would be to set it to public, but that would negate the option of "Specific people can access".
Sorry this is not possible yet in Google spreadsheet :(. But I am not sure if you have though of this solution yet;
You could make a duplicate of both the spreadsheet b and a so that " the other people" can't see your historical data.
Only issue with this is you would be remaking the whole thing:(
Hope this help!
According to Authorization for Google Services it's not possible because for Standalone, add-on, or bound to Docs, Sheets, or Forms the script run as the user at keyboard. The alternatives is to convert your script to a web app or to a Installable trigger.
Deleting a shared document will not change your group status. If you no longer wish to receive shared documents then I would suggest talking to your group administrator who may be able to put you in a category of "group member" but exclude you from the "share documents" group. This is completely up to how your group is organized and run though.
When other ...