# Rows in google spreadsheet not increasing **URL:** \ **Category:** Ask for Help\ **Created:** [September 26, 2021, 2:25am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330 "2021-09-26T02:25:38Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [September 26, 2021, 2:25am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/1 "2021-09-26T02:25:38Z")
the user fills out the form in glide, but it is not legible in GS. I attached a screenshot. GS ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f29bdaf3552123d12530fe40fc1cf6bf2b23b847.png) in Glide ![Capture.L](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/4/245444eef4e2d2badb1748640252a70892a71295.png) in Glide the latest data has been added… but in GS the latest data is not added you can check in the date column ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [September 26, 2021, 2:32am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/2 "2021-09-26T02:32:54Z")
Hola @agung_Taufik Try scrolling to the end of the Gsheet. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [September 26, 2021, 2:37am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/3 "2021-09-26T02:37:50Z")
if you are using the array formula function it will fill up the sheet all the way to the bottom, that’s why Glide is putting the next entry to the new row in GS… do not use =arrayformula( if( a2:a="","" use double “,” ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [September 26, 2021, 2:41am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/4 "2021-09-26T02:41:07Z")
thanks @SantiagoPerez… it’s true, the data is at the end of the gsheet, I use an arrayformula, is there a way to prevent that from happening? ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [September 26, 2021, 2:42am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/5 "2021-09-26T02:42:17Z")
I will try it… thanks @Uzo ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [September 26, 2021, 2:47am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/6 "2021-09-26T02:47:02Z")
easy to copy formula: `=ARRAYFORMULA(if(A2:A="",,row(A2:A))` replace **row(A2:A)** with your function and have Glide **row ID** in **A** column ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 26, 2021, 2:59am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/7 "2021-09-26T02:59:51Z")
Delete all of the empty rows in the sheet. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [September 26, 2021, 3:00am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/8 "2021-09-26T03:00:57Z")
nice reminder… you are the all-star pro! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 26, 2021, 3:42am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/9 "2021-09-26T03:42:13Z")
Not related to your question, but a couple of small pointers: ![Screen Shot 2021-09-26 at 11.36.26 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/6/0695ade5780e2f0458bb2fd5e71173096a4c0a2b.jpeg) The formatting of both of your date related columns looks wonky. The first one - DATE TIME - appears to be a date/time column, but the values are appearing as ISO formatted date/time strings. This is usually an indication that the column isn’t configured correctly. If you simply edit the column in Glide and save, that should fix that. And the second one - DATE - is configured as a text column. This will cause problems if you ever try to reference this column in computed columns, so I would advise fixing it. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [September 26, 2021, 4:02am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/10 "2021-09-26T04:02:46Z")
@Darren_Murphy you are a freak of nature… you made me analyze that image… and I do agree with your conclusion ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [September 26, 2021, 4:06am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/11 "2021-09-26T04:06:09Z")
Thanks to everyone who has helped me, this problem is solved thank you very much ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [September 26, 2021, 4:07am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/12 "2021-09-26T04:07:20Z")
@Darren_Murphy thanks for the correction, i will fix it… ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [September 26, 2021, 4:08am UTC](https://community.glideapps.com/t/rows-in-google-spreadsheet-not-increasing/32330/13 "2021-09-26T04:08:35Z")
Structure your data it is the Art of this DIGITAL world