I’m working on an app and it’s using some ARRAYFORMULA’s to reference data on different sheets, etc. The issue I’m having is that whenever someone “Adds” an entry, the ARRAYFORMULA seems to add a “0” row as well as the actual data to the other sheet.
The sheet in question is the “My Points” tab, which should take the values in the “My Activities” tab and sum them all up, then rank them according to highest total points. For some reason, when I add new rows (through to corresponding app), the formula in column B in “My Points” adds a new “0” row at the same time. This wouldn’t be an issue, but with the 500 row limit, I want to try to prevent this.
Any advice? Thanks in advance.