I’m facing some issues with formulas and new items.
We created an app to manage our stock. So basically we have a row per item, and users can add items throught the app, which adds a row to our sheet.
Two formulas are associated with the item. So we used the ARRAYFORMULA to show to result in the cell if the item’s reference is not empty. We scrolled down this formula until row #500, and we currently have 375 items.
The problem here, is that when we had an item through the app, it indeed add a row in the sheet, but in row 501, instead of 376, so our 2 formulas/cells stay empty. Glide consider that the rows betwen 375 and 500 are not empty because there’s a formula even though the cells are empty.
Does someone know how to add the new items in the empty rows where we have our fomulas ?
This would help a lot, thanks !