Arrayformula’s are best, but google will interpret a row that has a formula as a filled row and look for the next empty row to add data. That’s why dragging a formula never works. When using an arrayformula, it’s best to put in an IF statement to only use the formula when another column is populated, else return a blank value. Otherwise it will put something in the cell and glide will interpret it as a filled row. Also it’s best to delete all empty rows because the nature of arrayformulas fills every row in the sheet, regardless if you see anything in the cell or now. Otherwise google creates a new row and appends to the bottom of the sheet.
Here is a tutorial on using arrayformulas.
Glide does not interpret sheet formulas and will just treat it like text. However, keep in mind that depending on what you are trying to achieve, you can do a lot of functions within glide using math, rollup, if/then, etc. columns in the glide data editor.