New entry with spreadsheet formula produces error
I have several tables where some columns contain spreadsheet formulas. In some cases (maybe depending on the type of formula? Haven’t checked them all yet) when I enter a new item in the app, it does fill in the spreadsheet formula for the item’s new row, but it messes the formula up on the way.
The SUMIFS formula =SUMIFS(‘Rezept Zutaten’!I:I;‘Rezept Zutaten’!J:J;B236;‘Rezept Zutaten’!G:G;“TRUE”)+sumifs(L:L;B:B;B236;M:M;“TRUE”)
becomes this mess, which then produces an error in the sheet: =SUMIFS(‘Rezept Zutaten’!C[-8]:C[-8];‘Rezept Zutaten’!C[-7]:C[-7];B237;‘Rezept Zutaten’!C[-10]:C[-10];“TRUE”)
Why does this happen and how can I fix it? I don’t want to have to write a script to fill down formulas every time I enter a new item.
LinkedIn
Twitter
