Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I am looking for a way to automatically create a new row on top of older rows each day.

Inside of this row should be the current date.

share|improve this question
    
Were you able to implement my solution? –  Jacob Jan Tuinstra Sep 1 '13 at 18:30

1 Answer 1

With this little snippet it is possible. Add the code by selecting tools>Script editor in the spreadsheet. Make sure to press the bug button:

enter image description here

Code

function onTop() {
  var ss = SpreadsheetApp.getActiveSheet();
  ss.insertRows(2);
  var date = Utilities.formatDate(new Date(), "GMT+2", "dd/MM/yyyy")
  ss.getRange("A2").setValue(date);  
}

Triggers

In the script editor, choose the following menu option:
enter image description here

and set the trigger as follows (or however you choose): enter image description here

Example

I've created an example file for you: on top

Remark

You have to return tomorrow to check it though =)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.