{"id":1070,"date":"2016-01-05T16:22:44","date_gmt":"2016-01-05T14:22:44","guid":{"rendered":"https:\/\/tulipemedia.com\/?p=1070"},"modified":"2016-01-05T16:22:44","modified_gmt":"2016-01-05T14:22:44","slug":"google-sheets-importrange-function-sharing-file-planning","status":"publish","type":"post","link":"https:\/\/tulipemedia.com\/en\/google-sheets-importrange-function-sharing-file-planning\/","title":{"rendered":"Google Sheets: Use the IMPORTRANGE function to share part of a spreadsheet"},"content":{"rendered":"

Here's a little tip for sharing a portion of a document with Google Sheets, without having to share the entire document with your collaborators. I personally needed this function in order to share the schedule of each of my colleagues, without them having access to the overall schedule. I wanted everyone to be able to see theirs.<\/p>\n

If we stay with the example of the shared schedule, we have on one side the overall document, the one on which you are working, and on the other the different files that you are going to share.<\/p>\n

Once your overall planning is complete, all you have to do is create new spreadsheets in which you will use this function:<\/p>\n

=IMPORTRANGE("URL OF YOUR GLOBAL FILE";"sheetname!C1:C23")<\/pre>\n
With this line, you import cells C1 to C23 from the sheet titled \u201csheetname\u201d, and taken from the file whose URL you must enter. You can therefore continue to update your overall file, your collaborators will only see the changes made to their part. Practical for a schedule updated every week!<\/p>\n
And if you want to go further by sending an email from Google Sheets to your colleagues once the schedule is ready, and be notified of their confirmation, follow the leader<\/a><\/strong> !<\/p>","protected":false},"excerpt":{"rendered":"
Voici une petite astuce permettant de partager une portion de document avec Google Sheets, sans avoir \u00e0 partager le document entier avec ses collaborateurs. J’ai personnellement eu besoin de cette fonction afin de partager le\u00a0planning de chacun de\u00a0mes collaborateurs, sans que\u00a0ceux-ci n’aient acc\u00e8s au planning global. Je souhaitais que chacun puisse voir le sien. Si […]<\/p>\n","protected":false},"author":17,"featured_media":1071,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,28],"tags":[],"class_list":["post-1070","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-rh","category-vie-pro"],"_links":{"self":[{"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/posts\/1070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/comments?post=1070"}],"version-history":[{"count":0,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/posts\/1070\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/media\/1071"}],"wp:attachment":[{"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/media?parent=1070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/categories?post=1070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tulipemedia.com\/en\/wp-json\/wp\/v2\/tags?post=1070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}