Google sheet create row

When i create row into Sheet it’s creating last row but i want to add row 2 everytime. And sort date permanently.

I have columns A to P. In column B I have dates. Not at the end of the list for each new data entry. 2. I want new data entry to be added to the row, but it adds it to the end of the list. I am trying to do this before the old data disappears, I have not been successful. I say come on, it makes the data entry at the end, it makes the sorting automatically, it does not do it, it gets better when I sort it manually.

To summarize: there are main headings in row1. It should sort automatically according to the dates in column B.
When I make new data entry, it should appear at the beginning of the list, not at the end, although if we do the date sorting, it automatically puts it in order itself. So the important thing for me is to make the sorting in column b automatic.

i fixed with this script:

function onEdit() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var lastRow = sheet.getLastRow();
var lastColumn = sheet.getLastColumn();

var range = sheet.getRange(2, 1, lastRow - 1, lastColumn);
range.sort({column: 2, ascending: false});
}

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.