In this post, I demonstrate how to get the next open row and column using Google Apps Script on Google Sheets.
How to Video:
Video Notes:
- Apps Script (Script Editor) is now located under tab ‘Extensions’ instead of ‘Tools’ on Google Sheets
- Legacy Apps Script Editor Used in Video
Code in Video:
function lastRow()
{
var sheet1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
var lastrow = sheet1.getLastRow() + 1;
sheet1.getRange(lastrow, 1).setValue('CURT');
}
function lastColumn()
{
var sheet1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
var lastrow = sheet1.getLastRow();
for(var i = 1; i <= lastrow; i++)
{
var column = 1;
while(sheet1.getRange(i,column).isBlank() == false)
{
column = column + 1;
}
sheet1.getRange(i, column).setValue('CURT');
}
}
Related Posts



















