How to link spreadsheets with Google Script Editor?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box; 0 I'm trying to link two different spreadsheets - by that, I mean to different Google Spreadsheet files with each other. I want to be able to get data from one spreadsheet and do different functions in another. I already know how to share data between sheets, just not spreadsheets. Would love some help on this. Here's my code below: var app = SpreadsheetApp; // creates application var r_volunteers = app.getActiveSpreadsheet().getActiveSheet(); // creates spreadsheet, then gets active sheet named "raw_values" var housing_roster = app.getActiveSpreadsheet().getSheetByName("housing_roster"); // creates variable for housing roster sheet var totalOfVolunteers = r_volunteers.getLastRow() - 1; // -1 due to row of headers var sorting_range = r_volunteers.getRange(2, 2, totalOfVolunteers, 12