google sheets
I want to give someone a Google Sheets that I made so they can use it independently of my sheet. I don't want to ever be able to read/write/update their sheet. I'm aware there are various options for adjusting permissions on Google Sheets.
For example, if I email someone a text file and they edit it, I don't know what they've done to their copy and they don't know what I've done to mine.
How do I do this with a Google Sheets?
I am not sure I understand you requirement but perhaps a named range would help you. Take for example:
Now name A3 - the default would be NamedRange1. This can be used elsewhere in the same sheet or in other sheets in the same document with:
=NamedRange1
to return 6 wherever entered.
Now say change + to ^ in A3 above. Then all those 6 entries will change to 16.
If you don't mind using a macro, you can do the following. Add this script to your spreadsheet (Tools -> Scripts -> Script editor):
function getTotalSum(cell) {
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
var sum = 0;
for (var i = 0; i < sheets.length ; i++ ) {
var sheet = sheets[i];
var val = sheet.getRange(cell).getValue();
if (typeof(val) == 'number') {
sum += val;
}
}
return sum;
}
and use the formula =getTotalSum("A1"), where "A1" is the cell which you want to sum up in all the sheets (except the one you putting the formula in).
I made a test script which you can take a look at: https://spreadsheets.google.com/ccc?key=0Ao3E95ou1MgbdG45blRvWlVaYkxFY01PQUhvZkZQcEE&hl=en&authkey=CPyZqxk
Best Answer
You need to give them a modified shareable link to a copy of your file.
First, make a copy of your sheet:
File -> Make a copy...Second, create a shareable link with
can viewpermissions:Note the end of the url:
Finally, send them the URL of your sheet with
/copyappended on the end - it directly refers them to this page, by which then can then duplicate it and have their own copy:Note the end of the url: