# Formula error while adding row **URL:** \ **Category:** Report a Bug\ **Created:** [January 4, 2021, 8:58pm UTC](https://community.glideapps.com/t/formula-error-while-adding-row/20727 "2021-01-04T20:58:13Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Vladimir\_Zambakhidze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladimir_zambakhidze/32/13882_2.png) [@Vladimir\_Zambakhidze](https://community.glideapps.com/u/Vladimir_Zambakhidze)\ **Post date:** [January 4, 2021, 8:58pm UTC](https://community.glideapps.com/t/formula-error-while-adding-row/20727/1 "2021-01-04T20:58:13Z")
Good day. Has anyone encountered such an error? The cell contains a formula for splitting the value into different columns. When you add a string via “Add row”, some hidden values are written to the string that prevent the formula from being executed. They are not visible. But if you select this cell and delete the value, then the error disappears. When adding a line through the “Open form”, everything works correctly. Formula: =ARRAYFORMULA(IFERROR(SPLIT(A2:A, “,”),"")) ![Снимок экрана 2021-01-04 в 23.46.36](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f8831c4b2c5eb397d665e294759705feb8f5d09.png) ![Снимок экрана 2021-01-04 в 23.47.18](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6a0f921491f4c927b553c3b317c6f040be689b5.png) > **[FBike](https://foldingbike.glideapp.io/dl/ewAiAHQAIgA6ADYALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AUwBoAGUAZQB0ADEAMQAiACwAIgByACIAOgAiAEkAUQBMAGYATgA3AFcAVwBUAGEAYQAuAHAASQBWAFQANQBJAEIAdQByAGcAIgAsACIAbgAiADoAIgA1ADUANQA1ACwAIAA3ADcANwA3ADcAIgB9AA==)** ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 5, 2021, 12:01am UTC](https://community.glideapps.com/t/formula-error-while-adding-row/20727/2 "2021-01-05T00:01:28Z")
I assume you’re only using add row to add to column A, is that correct? Your formula seems to say you’re writing to column B (in cell B4), which should not happen. ---
**Author:** ![Vladimir\_Zambakhidze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladimir_zambakhidze/32/13882_2.png) [@Vladimir\_Zambakhidze](https://community.glideapps.com/u/Vladimir_Zambakhidze)\ **Post date:** [January 5, 2021, 9:43am UTC](https://community.glideapps.com/t/formula-error-while-adding-row/20727/3 "2021-01-05T09:43:26Z")
As you can see in the picture, I only write data to the Value column. But, apparently, Glide writes something else to other columns, which interferes with the execution of the formula. The error shows the presence of values in columns One and Two, although I do not write anything there and no values are visible in them. Error text: “Array is not printed because it will overwrite data in range B7” (C7). After manually clearing the values in B7 and C7 (although outwardly they are empty), the formula starts to work ![Снимок экрана 2021-01-05 в 12.28.18](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1dc69db2e1f9c3cf398da085bced645a7eceee34.png) ![Снимок экрана 2021-01-05 в 12.30.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20e2a17b2b0592201da378bdc07d53ef0f79cab4.png) ![Снимок экрана 2021-01-05 в 12.31.02](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e861d9a7abdad2507df68486efcb03bd09de6ffc.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 5, 2021, 9:49am UTC](https://community.glideapps.com/t/formula-error-while-adding-row/20727/4 "2021-01-05T09:49:51Z")
Seems like this is a bug I encoutered a while ago as well, I think you can email Glide’s support for this. It was starting to happen after they introduced the custom value for compound actions. ---
**Author:** ![Vladimir\_Zambakhidze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladimir_zambakhidze/32/13882_2.png) [@Vladimir\_Zambakhidze](https://community.glideapps.com/u/Vladimir_Zambakhidze)\ **Post date:** [January 5, 2021, 9:57am UTC](https://community.glideapps.com/t/formula-error-while-adding-row/20727/5 "2021-01-05T09:57:45Z")
Thank you. Yes, I already wrote. Interestingly, the exact same formula and add row in another application works correctly ---
**Author:** ![Vladimir\_Zambakhidze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladimir_zambakhidze/32/13882_2.png) [@Vladimir\_Zambakhidze](https://community.glideapps.com/u/Vladimir_Zambakhidze)\ **Post date:** [January 5, 2021, 10:31am UTC](https://community.glideapps.com/t/formula-error-while-adding-row/20727/6 "2021-01-05T10:31:45Z")
Did you manage to fix the error? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 5, 2021, 10:47am UTC](https://community.glideapps.com/t/formula-error-while-adding-row/20727/7 "2021-01-05T10:47:35Z")
I haven’t touched that app in a while but seems like from your post the error is still there. I ended up using a script to clear the column whenever there’s a new row so the arrayformula can run.