Google Sheets New Row Add to Bottom

How To
1

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.

1 Like
2

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
3

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

4

@ADEQ_GIS you can use formatDate function.

Cheers!

1 Like
5

Super late to the party, but if anyone’s interested I found a workaround to this.

  1. use Get Range values to find out how many current rows there are
  2. use the array aggregator to count the number of rows
  3. add a new row by taking the number of rows and adding 1 (if there are 200 filled rows, I want the next row added to be row 201)
    Screen Shot 2023-06-12 at 11.00.07 AM
    Screen Shot 2023-06-12 at 11.00.07 AM1413×786 99.2 KB

    c
1 Like