Row’s with formulas are considered filled rows. Glide looks for the first empty row to add new data. Because of that, it is advised to use arrayformulas instead to autopopulate the formula down and then delete all of the empty rows. When a new row is added from the app, then it will add the row to the sheet and apply the formula to the new row. Here is some additional information.