Google Sheets: Use the IMPORTRANGE function to share part of a spreadsheet

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.

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.

Once your overall planning is complete, all you have to do is create new spreadsheets in which you will use this function:

Don't miss business advice by email

No spam, just an email when new content is published.

=IMPORTRANGE("URL OF YOUR GLOBAL FILE";"sheetname!C1:C23")

With this line, you import cells C1 to C23 from the sheet titled “sheetname”, 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!

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 !

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *

 

WordPress is the content management system of choice for online website builders. About 30% of the internet platforms currently available online are built around this system which has the share https://buff.ly/4gTcUuk

🫘 Flageolet beans, white beans, lentils, broad beans, chickpeas and other legumes are the best “slow carbohydrates” for health.
👉 Discover the superpowers of legumes in their dedicated content on Blooness: https://buff.ly/4b4nnlc

🍞 Sourdough bread with ancient flours is a more digestible alternative to traditional bread.
Natural fermentation can improve digestion and nutrient bioavailability.
👉 Learn more about the best breads at http://blooness.com

Load more

Don't miss business advice by email

No spam, just an email when new content is published.

en_USEN