Google Sheets New Row Add to Bottom

I have a scenario that adds a new row to a Google Spreadsheet. I need the new row to be added to the bottom of the spreadsheet and I don’t see anywhere in the settings of the module to control this. Currently the rows are randomly added to the sheet and are creating a huge mess. The rows cannot be sorted as there is a monthly row of calculations that need to remain under each month. Please advise.

Hi @ADEQ_GIS,

By default, the “add new row” module adds a row on the first empty row. So make sure you don’t have any empty rows in the middle of your sheet and the rows will be added as expected.

2 Likes

Hi,

Within that new row, if we have a date column, how do we format that column so it has the date as mm-dd-yyyy?

image.png

@ADEQ_GIS you can use formatDate function.

Cheers!

1 Like