First of all, dragging down will not work since Glide will add any new rows after the last row with a formula. An arrayformulas would be much better as it grows with your data. Also using an arrayformula, it will be best to delete all empty rows. For Glide to not recognize a row as filled, you need to set up your formula with an IF to check if another field is filled in the row. If the other field is empty, the formula will return empty and be ignored by Glide.
1 Like