Hello, I’m not sure if this counts as a bug or a feature request, but it may be causing my app to crash. I have an if then else statement set up as follows: [image] My hypothesis is that because the Else statement default is to Enter Value, even if nothing is inputted, Glide is autonomously crea…

Are you sure you don’t have any other array formulas in your sheet?

Hi Naos, Thanks for your response. I do have numerous array formulas on the relevant sheet, as well as on all other sheets. Only this sheet has an If Then Else statement, and it is the only one resulting in this problem where 500 new rows are created, whereas other sheets with array formulae only a…

Hi Ran, Here’s a duplicate of the app and sheet: https://papaglidecomm.glideapp.io/ The affected sheet is called Order Summary. Still not sure though - is there a “Do Nothing” option for Else?

Thanks I could not find the problem May be I didnt understand you well Please tell me again what to do In that cases I usualy use: =ARRAYFORMULA(IF(ISBLANK (A2:A), “”, “Something…”))

[500 lines GIF] Thanks Ran - I’ve made the gif above to demonstrate the problem in action.

Hi Kefa In my side everything goes well and I dont see any sper rows adjusments

Hi, It happens specifically when there are no more extra rows in the “Order Summary” sheet, and glide is forced to make a new row to fill in the new data, but instead makes 500 new ones. If you check the relevant sheet to see that there are no available rows to be filled, and then try it again, you…

[image] Arrayformula storage issue Report a Bug OK, I think I understand this a little better now. I don’t think I realized that your sheet was built from a unique formula. I think the rows are being created by google when the UNIQUE formula hits the end of the sheet and…

Hi No,it is not the case in my side I realized that the sheet is very “heavy” and it takes some time to calculate I have no ideas

If x Then y Else Do Nothing

Report a Bug

Jeff_Hager May 18, 2020, 7:03pm 10

Topic		Replies	Views
Arrayformula storage issue Report a Bug	22	2002	June 4, 2020
500 rows Ask for Help	4	546	April 19, 2021
FORM data writing to Glide but NOT to Google Sheet Report a Bug	20	1439	July 7, 2020
IFS conditions Ask for Help	18	1430	October 12, 2020
User input data goes in row 455 rather than next empty row Feature Requests	5	953	September 12, 2020

If x Then y Else Do Nothing

Related topics