0

I am trying to create a, only on Open, function to go to the first blank cell of a specific sheets column in Google Sheets

Update I currently have a script that works - but it's quite slow onOpen. What are some possible ways to speed it up? The script:

function onOpen(e) {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Data");
  spreadsheet.getRange('C1').activate();
spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).activate();
spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).activate();
spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.UP).activate();
}
5
  • Welcome to Web Applications. Please show one of the scripts that you tried and describe what you tried to do to solve the problem. Ref. How to Ask.
    – Rubén
    Jan 5 at 18:31
  • Hi Ruben. I'll try to follow how to ask best practices in the future, thanks for pointing that out. I attached a script from here, changed columns, but with no luck.
    – Nuxurious
    Jan 6 at 20:37
  • 1
    Questions should be self-contained, to do that, add the script with the changes that you maid. If you got an error message also add it textually.
    – Rubén
    Jan 6 at 20:47
  • Hi Ruben. Through a macro, I was able to get something to work. However, it is quite slow at the moment, possibly due to the sheet having 70 columns and 700+ rows. Nonetheless, do you maybe have some suggestions to how I can improve the speed?
    – Nuxurious
    Jan 7 at 14:24
  • 1
    Hi Nuxurious. The spreadsheet size might be a factor but I think that other factor that has a bigger impact is the use of many getCurrentCell() and .activate() because they depend on the active user. Take a look to Script to have Google Sheets jump to the next available row in column A automatically? for other options.
    – Rubén
    Jan 7 at 15:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.