Very strange. 43s video here https://share.vidyard.com/watch/XxDZxRL3foQ6z88A3FPHDn ?

The way I would write your arrayformula: =ARRAYFORMULA(if(LEN(B2:B) = 0, ,randbetween(1,10))) Regardless, we suggest deleting all the empty rows Google puts in your sheet by default.

Glide doesn’t count empty rows, but Google does :stuck_out_tongue_winking_eye:

FORM data writing to Glide but NOT to Google Sheet

Report a Bug

david July 7, 2020, 12:34am 21

Glide doesn’t count empty rows, but Google does

Topic		Replies	Views
Arrayformula storage issue Report a Bug	22	1970	June 4, 2020
Blank in both GSheet and Glide data editor when users add profile data Ask for Help	11	747	July 22, 2020
Why is there a gap of blank rows of my Google Sheet? Ask for Help	2	264	November 8, 2021
Doesn't write on my Google Sheet Ask for Help	4	1873	January 25, 2020
User input data goes in row 455 rather than next empty row Feature Requests	5	946	September 12, 2020

FORM data writing to Glide but NOT to Google Sheet

Related topics