I have a script that I enter B2, B5, E2, & E5 that will add it to the bottom row of the list. I'm needing to add the formulas that are all different from columns E:Y along with it and be able to sort column A (alphabetically). Can Anyone help?
function addcustomer() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var customersSS = ss.getSheetByName("customers"); //customers Sheet
//Input Values
var values = [[customersSS.getRange("B2").getValue(),
customersSS.getRange("B5").getValue(),
customersSS.getRange("E2").getValue(),
customersSS.getRange("E5").getValue(),]];
customersSS.getRange(customersSS.getLastRow()+1, 1, 1, 4).setValues(values);
}