network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 1 month |
| seen | May 10 '12 at 19:59 | |
| stats | profile views | 3 |
|
Apr 24 |
comment |
Google spreadsheet loop through data validation fields This is getting a circular dependency error: function getTotalSum(cell) {
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
var row = sheets[1].getRange(cell).getRowIndex();
var sum = 0;
for (var i = 4; i < 8 ; i++ ) {
var sheet = sheets[i];
var multirow = sheet.getRange("F1:F70").getRowIndex();
for (var h = 2; h < sheet.getMaxRows() ; h++ ) {
var name1 = sheets[1].getRange("A"+row).getValue();
var name2 = sheet.getRange("F"+h).getValue();
if ( name1 == name2 ) {
var val = sheet.getRange("D"+h).getValue();
sum += val;
}
}
}
return sum;
} |
|
Apr 24 |
asked | Google spreadsheet loop through data validation fields |
