Multiple criteria sumif array formula with logic

[Jeff_Hager]

Is there more to this 500 row thing or is it a formula issue???

If x Then y Else Do Nothing

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 creating new rows to the maximum allowed (500) and filling in these newly created cells with the rule. Glide choosing to create these rows results in a vicious loop, where a trigger of the If Then Else st…