"google sheets script onedit sort for multiple sheets" Code Answer's
You're definitely familiar with the best coding language TypeScript that developers use to develop their projects and they get all their queries like "google sheets script onedit sort for multiple sheets" answered properly. Developers are finding an appropriate answer about google sheets script onedit sort for multiple sheets related to the TypeScript coding language. By visiting this online portal developers get answers concerning TypeScript codes question like google sheets script onedit sort for multiple sheets. Enter your desired code related query in the search bar and get every piece of information about TypeScript code related question on google sheets script onedit sort for multiple sheets.
google sheets script onedit sort for multiple sheets
function onEdit(event){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = event.source.getActiveSheet().getName()
var editedCell = event.range.getSheet().getActiveCell();
if(sheet=="Loan Inquiries"){
var columnToSortBy = 2;
var tableRange = "A3:T99"; //range to be sorted
if(editedCell.getColumn() == columnToSortBy){
var range = ss.getActiveSheet().getRange(tableRange);
range.sort( { column : columnToSortBy, ascending: true } );
}
}
else if(sheet=="Deals in Escrow"){
var columnToSortBy = 7;
var tableRange = "A3:T99"; //range to be sorted
if(editedCell.getColumn() == columnToSortBy){
var range = ss.getActiveSheet().getRange(tableRange);
range.sort( { column : columnToSortBy, ascending: true } );
}
}
else{return}
}
All those coders who are working on the TypeScript based application and are stuck on google sheets script onedit sort for multiple sheets can get a collection of related answers to their query. Programmers need to enter their query on google sheets script onedit sort for multiple sheets related to TypeScript code and they'll get their ambiguities clear immediately. On our webpage, there are tutorials about google sheets script onedit sort for multiple sheets for the programmers working on TypeScript code while coding their module. Coders are also allowed to rectify already present answers of google sheets script onedit sort for multiple sheets while working on the TypeScript language code. Developers can add up suggestions if they deem fit any other answer relating to "google sheets script onedit sort for multiple sheets". Visit this developer's friendly online web community, CodeProZone, and get your queries like google sheets script onedit sort for multiple sheets resolved professionally and stay updated to the latest TypeScript updates.