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.

Have You Tried reloading both glide and google sheets

Yup! and rebooted my computer, and deleted the tab that isn’t being written to and recreated it.

My only idea would be to check the bottom of the sheet, but you’ve obviously done that already.

I scrolled down to the bottom of your sheet and saw all of the data.

you can actually scroll that long

Welll, I am really bad at excel and I scrolled down to row 1000 (obviously not far enough). nevertheless, why is it writing way down on the sheet? Did I do something wrong?

FORM data writing to Glide but NOT to Google Sheet

Report a Bug

david July 6, 2020, 10:31pm 5

Can you please share a link to your app and add david@glideapps.com to your sheet so I can take a look?

Topic		Replies	Views
Arrayformula storage issue Report a Bug	23	1935	February 4, 2024
Blank in both GSheet and Glide data editor when users add profile data Ask for Help	12	728	February 4, 2024
Why is there a gap of blank rows of my Google Sheet? Ask for Help	2	258	November 8, 2021
Doesn't write on my Google Sheet Ask for Help	5	1862	February 4, 2024
User input data goes in row 455 rather than next empty row Feature Requests	5	945	September 12, 2020

FORM data writing to Glide but NOT to Google Sheet

Related topics